Forum Discussion

Tengmin123's avatar
Tengmin123
Frequent Visitor
5 years ago

Cannot display image in report builder from byte array or hex string

Hi, all,   I have a byte array (image) in json format in sql db. I extract the image out and also in json format. my query is: SELECT thumbNail FROM Table cross apply openjson(CMD_LIST,'$.queueMe...
Need Help
AbhiSSRS's avatar
AbhiSSRS
Solution Sage
5 years ago

The rdl supports Byte Array so you do not need to convert to hex! We have been converting the hex to bytearray if at all! Try to put this on a Dataset field and bind that to the image control. Also just to make sure the image mime is as of the original one.

 

 

 

  • Tengmin123's avatar
    Tengmin123
    Frequent Visitor
    5 years ago

    Thank you for your reply.  but my byte array is saved as varchar(max) in database, it is a string with byte array value. is it still ok for report builder to visualize it?

    • AbhiSSRS's avatar
      AbhiSSRS
      Solution Sage
      5 years ago

      Yeah it should work! try adding this convert 

      Convert.FromBase64String

      • Tengmin123's avatar
        Tengmin123
        Frequent Visitor
        5 years ago

        I tried add the convert and not add, but both not work for me.