all groups > sql server reporting services > july 2005 >
You're in the

sql server reporting services

group:

Reporting Services- Image files in database tied to file system


Reporting Services- Image files in database tied to file system Lisa
7/3/2005 1:03:02 PM
sql server reporting services:
How can I display images in a report in Reporting Services that have their
file name (example: picture.jpg) in a table, but the actual picture is in a
file on the network (example: c:\mydocuments\picture.jpg?

where in Reporting Services do i tie the field name (picture.jpg) from a
table to the file system (c:\mydocuments\picture.jpg)?

Re: Reporting Services- Image files in database tied to file system Chris McGuigan
7/4/2005 12:58:05 AM
Lisa,
You can use that fields value as the location of the image.
Assuming you have an image control on the report and its source
property is set to 'external', the 'value' property just needs to be
set to the relevant field. There is a drop down at this point you could
use to pick the field or you can type it in like;
=Fields!ImagePath.Value
where you would substitute 'ImagePath' with your field name.

Chris

[quoted text, click to view]
Re: Reporting Services- Image files in database tied to file syste Lisa
7/11/2005 12:16:01 PM
Thanks for the response! I changed my field to house the actual location of
the file -
example: http://localhose/photos/picture.jpg - and set the property to
external and jpg - But my picture still does not display..
any suggestions?

Lisa

[quoted text, click to view]
Re: Reporting Services- Image files in database tied to file syste Chris McGuigan
7/13/2005 12:20:13 AM
Lisa,
Something that often gets in the way is the permissions. When designing
the report it's looking at the images with your permissions. When the
report is deployed it is using the permissions of the account running
the Reporting Services service. Check these have rights to view the
images.

Chris

[quoted text, click to view]
Re: Reporting Services- Image files in database tied to file syste Lisa
7/13/2005 7:29:08 AM
Chris - thanks so much for your responses - the permissions on the picture
was the answer. However, I had to place the picture on the same server to
get it to work. Can you place it on a different server?
thanks again!
Lisa

[quoted text, click to view]
Re: Reporting Services- Image files in database tied to file syste Chris McGuigan
7/13/2005 9:08:53 AM
Lisa,
You can have it on other servers, but the Reporting Services server
needs to be able to see those locations - and have permissions.
Initially, use UNC paths if you can rather than URL's which you
mentioned in your example. I say this only because I've got this
working with UNC's but not tried it with URL's!

Chris


[quoted text, click to view]
AddThis Social Bookmark Button