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 presented this report at TLCC this year. It's a donor report I commissioned but the parameters run off activities and a list. Pretty simple just as Mason describes.
https://www.tessituranetwork.com/Items/Articles/Success-Stories/Network/SDC-List-With-Photos
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.
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