• Replies 13 replies
  • Subscribers 339 subscribers
  • Views 207 views
  • Users 0 members are here
Related

Images in an SSRS report

Graeme Ellis
$organization

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

Parents
  • $organization

    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

     

    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 :)

    Grae

    From: Stephen Lang <bounce-stephenlang9123@tessituranetwork.com>
    Sent: 2/5/2015 11:37:41 AM

    Were you able to figure out how to accomplish putting the images into a report?  I'm completely lost.




    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!

Reply
  • $organization

    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

     

    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 :)

    Grae

    From: Stephen Lang <bounce-stephenlang9123@tessituranetwork.com>
    Sent: 2/5/2015 11:37:41 AM

    Were you able to figure out how to accomplish putting the images into a report?  I'm completely lost.




    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!

Children