Search code examples
sql-serverimagereporting-servicesdynamics-crmblob

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

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 :

enter image description here

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

enter image description here

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

enter image description here

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?

Solution

  • See answer in this post below :

    Microsoft dynamics Mediaset Datatype and SSRS

    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.