Solved

Add Images To SSRS Report At Report Run Time

Posted on 2011-09-19
4
410 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

932 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now