Problem with External Images - Google Charts
Windows Server 2003 R2 x64 SP2SQL Server 2008 SP1 x64 (Only SP1 - no CU's or patches/fixes)SSRS 2008 SP1 - running in Integrated ModeSharepoint 2003 SP2RSSharepoint x64 - April 2009 Hi I'm unable to display external images in any report after deploying them to my report server, Like many others I can see the images in Visual Studio preview. It seems I've hit upon a common issue, but one which despite hours of googling and searching through this forum I've not been able to resolve. I've followed the many instruction posts on various websites which detail how to use external images. I've set the image properties in Visual Studio as follows, Source is set to 'External', and value is set to 'http://chart.apis.google.com/chart?chs=440x220&cht=t&chtm=europe&chco=ffffff,0000ff,cccccc,ff0000&chld=ATBEBXBGCYCZDKEEFIFRDEGRHUIEITLVLTLUMTNLPLPTROSKSIESSEGB&chd=s:AAAAAAAAAAAAAAAAAAAAAAAAAAAA&.png' (even a simple value such as 'http://www.google.co.uk/images/nav_logo7.png' fails.), MIMEType is left blank. The url I'm trying to use is derived from a SQL query, but even when I populate the above URL or any other for that matter in the value parameter directly/manually the behaviour is exactly the same, Visual Studio shows the image in preview, but SSRS in Sharepoint does not. I've read up on the use of the Execution Acount, but I can't see how that can apply in this senario as no credentials should be required to call up an image on a webpage such as Google, In any case I did try this and I set the report's datasource to use the execution account but it made no difference. Can anyone point me in the right direction? RegardsDan
February 18th, 2010 7:10pm

Hi, Since your images are hosted on the internet, you may check if your report server has an internet acces ?Hope it helps,Amaury.
Free Windows Admin Tool Kit Click here and download it now
February 18th, 2010 7:21pm

Good point, and one which I clearly missed off my list of ailments Needless to say the server has internet access, and I have check these URL's on that server. I should also point out that all these services are hosted on the same Windows ServerThanks for your help though.RegardsDan
February 18th, 2010 7:26pm

Sorry to have to bump this one, But I'm really stuck on this issue. I can't seem to get any images to display once my reports are deployed to my reportserver. In VS preview they display fine. I've spent literly hours/days looking into this but keep coming up with the same result - Nothing but little red crosses.Are there perhaps any setting in IIS that might block images from being called up?RegardsDan
Free Windows Admin Tool Kit Click here and download it now
March 1st, 2010 6:35pm

Which user is running the server? Does the server have an unattended execution account? Is the server behind a proxy? If yes, do these accounts have access to the proxy server?This posting is provided "AS IS" with no warranties, and confers no rights.
March 2nd, 2010 12:54am

Hi Tau, Thanks for your assistance, A domain\Adminstrator account is running the windows 2003 R2 server, a dedicated 'sql server' domain user is running the Reporting Services service. I've tried an unattended execution account using the same user as the Reporting services service as I stated in my first post but it didn't help, no change what so ever. The server does access the internet via a proxy, but its an unauthenticated proxy, therefore all windows users have access to the internet. Using Internet Explorer on the server I am able to view these images via their direct URL's but not within a deployed SSRS report. I hope this answers your questions, if you need for info just ask. Is there any method for testing internet access from RS on the server side?RegardsDan
Free Windows Admin Tool Kit Click here and download it now
March 2nd, 2010 2:27pm

Hello again, I've just tested the internet connectivity by adding the above google chart image into a sharepoint image viewer webpart, and that displays just fine, albeit it probably only renders at run time. I also ran this on the server and it works fine, so i'm guessing it has to be an RS issue. RegardsDan
March 2nd, 2010 6:49pm

Hi again, Following the above earlier posts, Does anyone know how I can check if RS has access/permission to use to the Internet. My server has access to the internet via proxy (the proxy setting are defined in IE, if I use IE on the server I can see full web pages and images) but it would seem the RS doesn't have access. Are there any setting I can check? - to eliminate confusion, I have once again enabled the execution account - again with no success, but it is active. ThanksDan
Free Windows Admin Tool Kit Click here and download it now
March 3rd, 2010 8:44pm

Dan, a few things to check:1) which user account is running reporting services ?2) which proxy server is being used for accessing external images?3) does the account in 1) have access to 2)? Hope this helps.This posting is provided "AS IS" with no warranties, and confers no rights.
March 12th, 2010 10:10pm

Hi Tau, Thanks for your reply, sorry for my delayed response, this was due to a spring vacation. As I stated in my earlier post "The server does access the internet via a proxy, but its an unauthenticated proxy, therefore all windows users have access to the internet." For all my hours of googling, I am yet to turn up and answer. Surely there must be a way to test internet access to a file via the command line? How is it that SSRS obtains its internet access is there an extra service that I need to enable? If anyone can shed some light on this I would be most grateful RegardsDan
Free Windows Admin Tool Kit Click here and download it now
March 26th, 2010 1:26pm

HI all, I'm still suffering with this issue, can anyone help? RegardsDan
April 6th, 2010 6:15pm

I am having the same problem. windows 2008r2 server with ssrs, trying to show static google maps. managed to get it to work for 10 minutes while messing with the GP in relation to this user, but then they stopped working again. how does SSRS 2008 R2 access the internet? I am trying to display ANY internet image and it does not work. does SSRS not look at the Proxy settings on the server / user when it tries to request the image? TrubyTruby
Free Windows Admin Tool Kit Click here and download it now
March 21st, 2011 7:48pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics