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
Graeme,
We have dynamic images on one of our dashboards. If the customer is connected with facebook we show their facebook profile pic on the report.
Jon
Hi Jon,
Thanks for this. Do those images pull dynamically straight out of Facebook? Our images are .jpg file. I was wondering where the best place to house them on our network so they pull through to reports.
Grae
Yes the images are right from facebook. We only have the facebook id stored and then use it to build up what the url should be for the profile pic.
Hi Guys,
I was looking at how to do this. I've loaded a few 'dummy' pics into the database, but I'd rather pull them dynamically from somewhere. i just wonder if, because we are on RAMP, that might prevent us from doing it. I stops me from using moving images in the headers.
Debbie
Were you able to figure out how to accomplish putting the images into a report? I'm completely lost.
I've had no luck, I'm afraid. I've not had any luck working out how to pull images off our network. Hopefully someone will be able to jump in here and tell us where we've been going wrong :)
Ryan,
Is it possible to use an image stored in T_CUST_DOC?
For small, reusable images you can deploy them directly to the report server alongside your reports. You can add them in your project in Visual Studio and then reference them inside the report.
For more dynamic needs (such as constituent images), it’s not ideal to host thousands of images on the report server, then you can either host them in the DB (as varbinary column data) or you can get them from a hosted URL or filepath. To host from a filepath, they need to be accessible from the SSRS ReportServer service (both for the user and server). Look at the Reporting Services Configuration Manager for the windows user to note when looking at file permissions.
A quick web search should come up with a few sites on how to do this.
=>Ryan Creps
@Tessitura Network
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Graeme Ellis Sent: Thursday, February 5, 2015 12:18 PM To: Ryan Creps Subject: Re: [Tessitura Technical Forum] Images in an SSRS report
From: Stephen Lang <bounce-stephenlang9123@tessituranetwork.com> Sent: 2/5/2015 11:37:41 AM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Unfortunately it is not due to encoding that occurs when saving from the client application to that table.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Stephen Lang Sent: Thursday, February 5, 2015 1:21 PM To: Ryan Creps Subject: RE: [Tessitura Technical Forum] Images in an SSRS report
From: Ryan Creps <bounce-ryancreps9649@tessituranetwork.com> Sent: 2/5/2015 5:52:30 PM
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.