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

Display Binary Image in Report Builder from Database Expand / Collapse
Author
Message
Posted Friday, April 25, 2014 12:09 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 12:58 PM
Points: 138, Visits: 813
Anyone have any suggestions on how to display a Binary Image in Report Builder 3.0? I'm trying to display the TemplateImage it is DataType "Image" which as I understand is Binary.

The table I have has only 4 Fields

ClinicalTemplateID (PK, numeric(18,0), Not Null
TemplateVersion (PK, smallint, Not Null)
TemplateImage (image, not null)
CreateDate (datetime, not null)


Here is the first few characters of the IMAGE value.
0x789CED5D7B6FE33892BFBF17D8

Any guidance is appreciated!

Thanks Thomas




***SQL born on date Spring 2013
Post #1565216
Posted Tuesday, April 29, 2014 7:28 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 2:57 PM
Points: 389, Visits: 2,306
thomashohner (4/25/2014)
Anyone have any suggestions on how to display a Binary Image in Report Builder 3.0? I'm trying to display the TemplateImage it is DataType "Image" which as I understand is Binary.

The table I have has only 4 Fields

ClinicalTemplateID (PK, numeric(18,0), Not Null
TemplateVersion (PK, smallint, Not Null)
TemplateImage (image, not null)
CreateDate (datetime, not null)


Here is the first few characters of the IMAGE value.
0x789CED5D7B6FE33892BFBF17D8

Any guidance is appreciated!

Thanks Thomas


All the google hits I see on 0x789c point to a 'zlib compressed' format, ie., it just might not be displayable as is without conversion. Chances are that the app that stores it also decompresses it when needed and that you'll subsequently have to find out what format this binary decompresses TO (even if you can manage to get a decompressed version of the column delivered to report builder).

2 cents, and they could be wrong too!
Post #1565913
Posted Tuesday, April 29, 2014 7:54 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 12:58 PM
Points: 138, Visits: 813
Great reply, Thanks so much. I do know the Application uses a SVG viewer to open other IMAGE files but beyond that I'm at a loss.



***SQL born on date Spring 2013
Post #1565934
Posted Tuesday, April 29, 2014 8:09 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 2:57 PM
Points: 389, Visits: 2,306
Makes some sense! According to http://stackoverflow.com/questions/15136264/how-can-i-say-a-file-is-svg-without-using-a-magic-number SVG uses xml (as vector formats are probably primariliy a description of how to draw something instead of a description of the end results ie., bitmaps or what actually got drawn LOL) and I bet that is very compressible. On the other hand, looking at report builder, svg is not one of those that you're going to be able to pull from a column and display as an image (I see listed bmp, gif, jpeg, png, x-png).
Post #1565941
Posted Tuesday, April 29, 2014 8:57 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 12:58 PM
Points: 138, Visits: 813
I have a feeling this conundrum is approaching the limit of my skill set as I understand very little about how images are rendered. I wish Report Builder supported SVG and other image types or that there was a way to covert that field to something Report Builder did use like the file types you listed. However I know wishing isn't worth much.



***SQL born on date Spring 2013
Post #1565987
Posted Tuesday, May 6, 2014 10:03 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 3:51 AM
Points: 10, Visits: 31
thomashohner (4/25/2014)
Anyone have any suggestions on how to display a Binary Image in Report Builder 3.0? I'm trying to display the TemplateImage it is DataType "Image" which as I understand is Binary.

The table I have has only 4 Fields

ClinicalTemplateID (PK, numeric(18,0), Not Null
TemplateVersion (PK, smallint, Not Null)
TemplateImage (image, not null)
CreateDate (datetime, not null)


Here is the first few characters of the IMAGE value.
0x789CED5D7B6FE33892BFBF17D8

Any guidance is appreciated!

Thanks Thomas


Try following two older threads. Sorry for unable to summerize the most useful information for you. I am a newbie.

http://www.networksteve.com/enterprise/topic.php/Display_image_from_custom_list_in_report_+_Report_Builder_3.0/?TopicId=23685&Posts=6

http://www.dbforums.com/microsoft-sql-server/1670865-report-builder-3-0-external-images-not-loading.html
Post #1568269
Posted Wednesday, May 7, 2014 6:34 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 12:58 PM
Points: 138, Visits: 813
Thank you I will look at them now



***SQL born on date Spring 2013
Post #1568415
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse