Hello everyone,
We're looking to pull photos of our members into an SSRS report, the filename for the images is <constituent_id>.jpg although I'm having a little difficulty working out the path to include in the SSRS report to select the correct image.
Has anyone else managed to pull dynamic images into SSRS reports?
Many thanks
Graeme
I know that this thread is from a long time ago, but I have a report set up that will dynamically add images just as you said. In the Tessitura file system (kriostess), which you can access using File Mover, we have a folder in Impftp called ConstituentImages that contains images of constituents with their id as the filename, just as you stated. In the SSRS report that goes along with this, I have the image properties set to pull image with the following expression:
="file:\\kriostess\pub\YOURSERVER\Live\Impftp\ConstituentImages\" & Fields!customer_no.Value & ".jpg"
Using this, the report works just fine. Hopefully this helps someone out!
Here at NIDA we have images for a small number of constituents in a couple of reports - we keep the images in mail2 but I really like Heath's idea of keeping the images on a local server (we're on RAMP too).
One thing though - we have an attribute held against the constituent record to hold the name of the .JPG image - it helps a LOT when the record is involved in a merge and is the delete_ID record.