How to display dynamic images in SQL Server Reporting Services

• navpreet.khurmi

  SSC Eights!

  Points: 933

  More actions

  April 3, 2009 at 8:11 am

  #198964

  Hello,

  I am creating a Report in SQL Server. The report uses a SQL statement.

  For Example "Select * from Persons where personId = @Id"

  In the Persons table I have a column Link_To_Picture ( C:\\Images\Person_1.jpg)

  Now I want to show the person picture in SQL Server Report.

  How can I do that?

  Kindly Advice.

  Thanks.

• Arun Sathianathan

  Default port

  Points: 1442

  More actions

  April 3, 2009 at 9:50 am

  #971698

  Follow the below method to read the file using SP

  http://www.java2s.com/Code/SQLServer/Insert-Delete-Update/InsertingImages.htm

  (use single quotes instead of double quotes as mentioned in the sample. You can insert this to a temp table.)

  Then use the below way to display the image in SSRS

  http://msdn.microsoft.com/en-us/library/ms156342(SQL.90).aspx.

  Cheers,

  Arun