Problem with external images

Hi!

I've got a real problem with inserting images into report. The problem is that I work with Reporting Services and SharePoint Portal. My employer wants to have CV created dynamically. Information for CV is taken from database under special account with read-only access. And photos of employees can be found with URL

http://corporate-site/Resources/Team/Name_surname.jpg (this string is also generated dynamically). When I preview report on my local machine, everything is Ok, I can see the images. But when deployed the images are not displayed. I have created an Unattended Report Processing Account to get photos. But if I want to use it I must change account for reading data from Data Source (in my case it is SharePointDB.rds) for “Credentials are not required”. And after it I can't get the information for CV.

Does someone know how to use one account for database and another one for getting external image? Or maybe there is another solution for this problem?

Thanks.

Yuliya

The configuration of the unattended account have changed as of February but there is also a solution of how to use url for your reports images, another option is to use stored procedure which means you have to use rectangle for the images and still another option is to store your images with your project. I did the later for a very complex report with just minor problems but it was accepted by the customer. The image control is just like visio shape so your can adjust your images as needed if you did not use the rectangle.

http://blog.toddtaylor.com/PermaLink,guid,b1517702-ad4b-48e1-a6e3-b736e8a982cb.aspx

http://technet.microsoft.com/en-us/library/ms156302.aspx