April 3, 2009 at 8:11 am
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.
April 3, 2009 at 9:50 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy