How can I display images in an SSRS report?

I am trying to display student photographs in an SSRS report. I am using SQL Server 2008, Visual Studio, and only a thumbnail is displayed, instead of the actual photograph.


report in design mode

All the info is contained in a database. The database does not contain the actual photographs, but a "txtPath" field containing the URL of the . jpg image for each student.

Here's what I am doing : I have created a very simple test report, and in the report dataset I have the PicID, StudentID and the txtPath in the "image" box.


ee-image-properties.JPG


The txtPath is this : (example) : https://<SERVERNAME>/files/studentimages/2012/4-Dec-2012/Alan%20Gill.jpg            (with the SERVERNAME and student name anonymised)


database grid showing fields
 
When I run the report, only a thumbnail is displayed instead of the photo. I know that the photo is accessible, because if I click on its hyperlink (outside of the report), it then displays the photo.

If I add the txtPath as a column in the report, and set the textbox action to "Go to URL", the photo displays when the URL is clicked.


Go to Report

My goal is to have the photos display when the report is loaded.

Am I doing something wrong, or missing out something here?

Thank you!
ict supportAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Arifhusen AnsariBusiness Intelligence Developer and AnalystCommented:
Hello,

I woud suggest you to first show your image url in the text box in Report and try to copy that path and open it.

It will help you to debug problem whether there is no image on that path or not.

If image is already available and problem is with ssrs report.

You can use the sample ssrs file i have attached to have an idea how to give reference to external image path.

Hope it will help you.
ShowImageFromLink.rdl
0
ict supportAuthor Commented:
Hello Arifhusen, thank you for replying.

You said :
//I woud suggest you to first show your image url in the text box in Report and try to copy that path and open it.//

I had already done that, and the URL is fine in itself, and opens up the photo. I think it's something wrong with the report, but I'm not sure what.

Jim
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ict supportAuthor Commented:
Hello Arifhusen,

I have discovered what the problem is - it is the fact that the physical images are on a different server (and require permissions).

The picture hyperlinks work, so that is acceptable to the users.

Thanks for you help.

Jim
0
ict supportAuthor Commented:
It is the fact that the physical images are on a different server (and require permissions).

The picture hyperlinks work, so that is acceptable to the users.

Jim
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.