Help for using (exernal images) from the website with SSRS

Question

I have a small web site where i maintain users data. I maintain the users data in table and store there images like /images/users/user_id.jpeg on the server.

I am using the ReportViewer control in the asp.net page to show the reports from SSRS in the web application.

Now user want reports where they can see the users image in the report so that they can export it as pdf and get it printed.

In report i tried html image tag with full and relative url with option to render HTML however its not working. Also i tried the image control in the toolbox with external url and that too appears to be now working. Can someone please help me get around this problem or guide me to some helpful links. Thanks all,

Answer 1

It will be a lot easier to set up the report so that your users can see the image, if you can see the image in preview in Report Designer.

1. Make sure you have a working URL that takes you to one of your images. Test it, by pasting the URL into the address bar of your browser and ensure that the image is displayed in the browser.

2. Delete the existing image from your report. Insert a new image into the report object (normally a list or table) you are using to display your table. (This should be where the old image was.)

3. Specify Web as the image source, and enter your working URL as the URL of the image.

4. Preview the report in the report designer. You should be able to see the image (with the hardcoded URL) displayed correctly in the report.

5. Assuming all images are stored in the same directory on your server, switch to the layout tab of your report designer and click on the image object. In the Properties window, the value attribute should be the harcoded URL.

6. Click on the <Expression...> option from the dropdown menu for the Value attribute. Edit the expression so that it says ="your URL, without the filename" & Fields!your image filename data field name.Value

7. Preview the report in the report designer. You should be able to see the appropriate image for your data displayed correctly in the report.

8. If everything has gone correctly up to this point, deploy the report and try viewing it in the Report Manager. You should be able to see the appropriate image for your data displayed correctly in the report.

At this point, your users should now be able to see the report images.