Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS 2005 Display .jpg files based on query result field holding a URL for the file Expand / Collapse
Author
Message
Posted Tuesday, November 24, 2009 10:43 AM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 9:08 AM
Points: 28, Visits: 97
I tried to put an "image" box into a table grid but the image wizard couldn't resolve a field name where it expected a "url". And using just the field properties, to point at the field containing the url, it will only display the url as a link, not as an image.

Someone suggested that it is not until SSRS 2008 that such abilities are native to SSRS, but even that is suspect, and besides, we don't have SSRS 2008.

Post #824037
Posted Tuesday, November 24, 2009 1:15 PM


SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 9:08 AM
Points: 28, Visits: 97
Found the simple answer, very simple. Just drop the image box onto the layout table grid, click "Finish" next at the first Wizard prompt, and "Finish" again to get rid of the Wizard,then go to the properties sheet, the Data section, pick external for source and put the field name for the "value". Below that a little ways in the properties sheet Layout section you can set the "Sizing" value to whichever of 4 types fits your need. "FitProportional" works well if you want to shrink things a bit.
Post #824111
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse