Solved

Add Images To SSRS Report At Report Run Time

Posted on 2011-09-19
4
414 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 40

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 40

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
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.

740 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