Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

URL Based Images using SSRS

 

For header images, I typically embed an image into the report. However, there may be times when you need to create a report that makes use images from an external location. In this quick and simple post, I am going to show you how to point to an image that is located on the internet.

 

All you have to do is add a picture to your report design surface. Then set the Source to be “External” and the Value property of the image to the location of them image on the web. For example, in my example below, I used a link to Google’s logo. Figure 1 below shows the items to modify to link to an external image.

 

Figure 1: Setting up the Image Properties

Setting Image Properties - Brian K McDonald

 

Since Google changes these images frequently, depending on when I run my report, I may get a different image. However, figure 2 shows you the results as of today.

 

Figure 2: Results

Results - Brian K McDonald

 

 

Now one thing to make note of is that when you deploy a report using external references like this out to a report server, the report server must be configured with an unattended execution account in order for the referenced URL (picture in this case) to work.

 

I hope that you have enjoyed this post. If you did, please take just a moment to rate it below! Also, if you don’t already, please be sure to follow me on twitter at @briankmcdonald. Also note that you can subscribe to an RSS feed of my blogs or find me at any of the below methods.

 

 

Brian K. McDonald, MCDBA, MCSD
Business Intelligence Consultant – Pragmatic Works

Email: bmcdonald@pragmaticworks.com

Blogs: SQLBIGeek | SQLServerCentral | BIDN | SQLServerPedia

Twitter: @briankmcdonald

LinkedIn: http://tinyurl.com/BrianKMcDonald

 

 

Comments

Posted by Anonymous on 13 December 2010

Pingback from  Twitter Trackbacks for                 SQL Server Central, URL Based Images using SSRS - BrianKMcDonald         [sqlservercentral.com]        on Topsy.com

Posted by Anonymous on 14 December 2010

Pingback from  Dew Drop – December 14, 2010 | Alvin Ashcraft's Morning Dew

Leave a Comment

Please register or log in to leave a comment.