SQL Server Performance Forum – Threads Archive
Images via file Path
I’ve a table which contains a column which references an image on a file server. Is there any way to get SRS 2005 to display an image from a file path? ThanksGlenn
See thishttp://msdn.microsoft.com/msdnmag/issues/04/08/SQLServerReportingServices/default.aspx to get it. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Satya – I read the article (which I had read back in 2004). I think that you may not have understood my statement/request. We already have image files on a file server on the network. Records in the SQL Reporting Service report resultset contain a column which references individual image files (via a filepath). What I need to do (which SRS 2005 apparently can’t do) is to include the image in the reports for each record. If the image was stored directly in the database the SRS could easily display the images. Why Microsoft left out the ability to reference an image via a filepath in the resultset records is beyond me…
I believe you need to explicitly specify the statements to display at that point, may be a function is helpful here. I will post here if I get any more information on the subject. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>