Coming soon - Get a detailed view of why an account is flagged as spam!
view details

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

6
SSRS Question - displaying images from URL created by query results in tablix
Post Body

Hi all! I'm hoping someone can help with this - I've found a lot of articles that are *close* to what I'm looking for but I'm not familiar enough with SSRS programming to translate it to something I can use....

I want a SSRS report that displays the jpg image of an item in a row alongside the other data. (Similar to this example)

I'm querying an inventory database, so lets say it's something like

SELECT itemcode, description, imagefile from INVENTORY

"imagefile" is extension included like "item.jpg"

I want the full web URL so I set the text field as http://www.company.com/[ImageFile] and it displays the result I want like https://www.company.com/item.jpg

How can I think tell SSRS to take that "dynamically created" URL and display the image?

Every example I've found so far requires the image file to be embedded.

thanks in advance for any help you can offer!

Author
Account Strength
100%
Account Age
11 years
Verified Email
Yes
Verified Flair
No
Total Karma
11,779
Link Karma
1,595
Comment Karma
10,074
Profile updated: 5 days ago
Posts updated: 8 months ago

Subreddit

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.
Posted
2 years ago