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!