Referencing images on a hard drive from reporting services 2005

Question

1.  I have picture images on hard drive(s) simular to the following, the images are not stored in the database only a reference. The images will always be on the same PC running sql server.
c:\cyclops\2008\08\29\imag1.jpg
e:\test\2007\07\02\image2.jpg

2. I have a field in the sql 2005 database that stores the location of each image as shown above.
3. I have created the following sql to return the image location from the database (Select ReportImage from ReportImage).
4. I have used a table with an image item within a body cell and set the folowing properties  for the image item using reporting services 2005:
Source = External
Value =  =Fields!ReportImage.Value
MIMEType = image/jpeg

4. When I run the report in preview mode I get the following error:

[rsUnsupportedProtocol] The image ‘image5’ has the URL “C:\Documents and Settings\steveha\My Documents\My Pictures\vcimage.bmp” as one of its properties. URLs in reports must begin with one of the following prefixes: http://, https://, ftp://, file:, mailto:, or news:.

5. So my question is how do you display images within a report where the images are on a hard drive and not in the database or on a web page? Thousands of these images exist and there size can be upto 200K.

Answer 1

 Thanks for your post, however I regret to inform you this is not the correct forum to get you the answers you need.

Please re-post your question at the following forum and they should be able to assist you:

http://forums.microsoft.com/TechNet/ShowForum.aspx?ForumID=82&SiteID=17

---

Hongwei Sun -MSFT

Answer 2

modify your query to include 'file:' as,

select 'file:'+ ReportImage from ReportImage