SSRS Report Builder 3.0 Link File To Network Folder

Scamquist
Scamquist used Ask the Experts™
on
I am trying to dynamically link a photo to an external file on the network.
I inserted an image box. selected External and entered the following in the expression:

="file://SSEPICOR10/EpicorData/EmpPhoto/SS/" & Fields!PhotoFile.Value & ".bmp"

All I get is a red X when I run the report.

Any help will be appreciated.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
WRHaslamSystems Integrator

Commented:
Have you checked that the account running the SSRS service has permissions to the folder the report references?

Author

Commented:
Yes.  The permissions are OK.  I found a work-around I will post.  Thank you for the comment.
I found a work-around.  The Report Server did not have an Images folder.  I added the folder and uploaded the employee photos to this folder.  I was able to reference the photo using the expression ="/Images/" & Fields!PhotoFile.Value & ".bmp"

Author

Commented:
After a few days, I found another solution.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial