Solved

Add Images To SSRS Report At Report Run Time

Posted on 2011-09-19
4
412 Views
Last Modified: 2013-11-28
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
Comment
Question by:mpeacockbc
  • 2
  • 2
4 Comments
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 36563098
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
 
LVL 1

Author Comment

by:mpeacockbc
ID: 36563562
@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
 
LVL 1

Author Comment

by:mpeacockbc
ID: 36563688
@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
 
LVL 39

Expert Comment

by:lcohan
ID: 36570134
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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

827 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question