How to Display BLOB images from Dynamics (running on SQL Server 2016) in SSRS

Question

I currently have a Navision Dynamics installation on SQL Server 2016.

I have a requirement to display pictues from Navision Dynamics CRM on a stand alone installation of SQL server reporting services (SSRS).

This means, I do not have any of the CRM functionality available for me to use.

The Data Sets for the report is standard SQL queries.

My test query and result :

The field Content from my above query is what I want to display as the image on the report.

If I look at the SQL datatype for the Content column, it says it is an Image (data type).

However, in dynamics, it is a data type of BLOB

I have tried to do this in the report and I just get a Red Cross (X):

I have also tried the following for this field and still get the red X :

=System.Convert.ToBase64String(Fields!Content.Value)

How do I go about displaying the Content field as an Image in the report please?

copy and paste the content here: https://codebeautify.org/base64-to-image-converter# — Sxntk, Jan 20 '21 at 19:40
Thanks.. it doesn't appear to be base64 unfortunately. Any other ideas? — Harry, Jan 20 '21 at 19:47
Maybe try https://stackoverflow.com/questions/6911460/blob-to-string-sql-server — Sxntk, Jan 20 '21 at 20:04
Great.. not sure how I didn't come across that one! thanks. I have asked our developers to change the compression on the field and then I can test. I'll keep you posted! — Harry, Jan 20 '21 at 21:00
@Sxntk Uncompressing the BLOB field and simply displaying it straight without any conversion worked like a charm for me. Thank you for the pointer. :) — Harry, Jan 22 '21 at 01:39

score 0 · Accepted Answer · answered Jan 22 '21 at 01:49

See answer in this post below :

The questions is same / similar to this one.

The answer is - Change the image compression on the BLOB field to OFF and then everything else should work like in the question.

1 Answers1