How to Load External Images into a Reporting Services Report Dynamically
Posted on 2010-08-12
I want to load images into a report dynamically for a specific product. For each product I seek to view the report for, there may be no image, one image or multiple images. These images are stored in an external file system and their path is stored in a database table column called PhotoLink. I run a stored procedure that accepts ProductNumber as an input parameter and returns the file path for the image(s) stored in the Database table PhotoLink column. The path looks similar to this one:
file://ABC02YGK/Photos/XYZ-12342-002 (1000 XXX)[HB]-1.jpg
In the reports layout view, I have added an image control from the toolbox and set the following properties:
When I run the report, the report asks for the ProductNumber as input parameter and correctly renders the image in case the product has only one image path stored in the database table column “PhotoLink”. Until here there is no issue. However, I need to further enhance the report and should dynamically add and populate single or multiple image controls to the report depending upon the number of images this product contains. Is this possible at all and how can I achieve this?