Avatar of orther
orther
 asked on

Image not displaying when Published to SQL Server Reporting Services

I have a report that displays a rotating banner ad at the bottom.  Every hour it changes between Banner1, Banner2, and Banner3 from an external link.  The expression reads as follows:

=choose((hour(now()) mod 3)+1,"file://dynamics/GPShare/images/banner1.PNG","file://dynamics/GPShare/images/banner2.PNG","file://dynamics/GPShare/images/banner3.PNG")

This works perfectly while in development but once I publish to SQL Server Reporting Services the image only displays a red "X".

I have verified that the permissions to the "images" directory have full access for the Everyone group and the Domain Users group.
SSRS

Avatar of undefined
Last Comment
orther

8/22/2022 - Mon
shorak

I havnt used much images in my reports but the way I do it is to include the images as part of the project instead of linking them externally and then deploying the images to the report server along with the reports and it works fine.

If you can find a solution to your problem then have a look at the link below:

http://msdn.microsoft.com/en-us/library/ms156388.aspx
orther

ASKER
I want to use an external link to the image from a directory so that it is easy for our graphic artist to change or update.  Also, because many reports access these same images, I only need to make one change and all of my reports are updated.
ASKER CERTIFIED SOLUTION
shorak

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
orther

ASKER
that did the trick, thanks
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes