April 25, 2014 at 12:09 pm
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:-)
April 29, 2014 at 7:28 am
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!
April 29, 2014 at 7:54 am
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:-)
April 29, 2014 at 8:09 am
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).
April 29, 2014 at 8:57 am
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:-)
May 6, 2014 at 10:03 pm
thomashohner (4/25/2014)
Anyone have any suggestions on how to display a Binary Image[/url] in Report Builder 3.0? I'm trying to display the TemplateImage it is DataType "Image[/url]" 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.:-D
May 7, 2014 at 6:34 am
Thank you I will look at them now:-)
***SQL born on date Spring 2013:-)
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply