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
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.