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.