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!
I just wondered if this is still legal. I believe that the new GDPR regulations (in the UK at least) prohibit it unless you have specific authority from the Customer or Staff Member.
Debbie