SQL Server Performance

Images via file Path

Discussion in 'SQL Server 2005 Reporting Services' started by gowens, Mar 6, 2007.

  1. gowens New Member

    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?

    Thanks
    Glenn
  2. satya Moderator

  3. gowens New Member

    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...
  4. satya Moderator

    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.

Share This Page