[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Add Images To SSRS Report At Report Run Time

Posted on 2011-09-19
4
Medium Priority
?
419 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 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

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.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

649 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