• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 421
  • Last Modified:

Add Images To SSRS Report At Report Run Time

Hello Experts
I need to create an SSRS report, that will show some SQL data and an image of the associated product. The image's path will be generated from the SQL Guid code. The images themselves are stored on a seperate file server.
So my goal is to have the report run, generate the report and on each line, use the generated path to get the correct image from the file store.
Hope that makes sense.
Where I am having an issue, is getting the image to display.
It is coming up blank every time, even though the tested path is accurate.
the image holder is set to External (but I have tried all other options in the drop list)
I have tried recreating the path as an expression but this just comes up with an #error

Any guidance would be appreciated.
Thanks
0
mpeacockbc
Asked:
mpeacockbc
  • 2
  • 2
1 Solution
 
lcohanDatabase AnalystCommented:
Does the NT user(login) running the report has at least Read access to that path/image.file?
SSRS is using NT authentication and I'm pretty sure all related items to your report must follow the rule.
Also check the report Security under the Report MAnager and make sure NT user(s) have all rights to run it including all components.
0
 
mpeacockbcAuthor Commented:
@lcohan: I will double check, but I am certain that the user account has access. i can open the images directly so Im assuming so. Unless it is the SSRS service account that also needs access to the file store folder?
0
 
mpeacockbcAuthor Commented:
@lochan: Aarrrggg... Its obviously Monday!
I did have access to the folder but I guess the report is run under the SSRS context? I changed security on the folder to include Authenticated Users for Read Only and Voila! I have images in my reports.
Thansk for your help in knocking some sense into my head.
0
 
lcohanDatabase AnalystCommented:
Sorry didn't get back to you earlier but yeah....as you noticed it is all around NT authentication - SSRS service account and NT users running the reports after that.
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now