CODEWITHSUNDEEP
sql-server-2008reporting-servicesdynamics-ax-2009axapta
Don
Don

Reputation: 49

Reading data from SQL image field

In AX 2009, I need to query and report from the SYSDATABASELOG table's DATA field (type IMAGE) in an SSRS report. However, it appears to be stored as raw data, and I need to be be able to read/interpret this field.

Thanks in advance.

Upvotes: 1

Views: 1049

Answers (1)

Gil Peretz
Gil Peretz

Reputation: 2419

I had this issue before, also using SSRS reports.

What you should do is to convert the SSRS image source from Embedded to DB.

your initial data should look like this:

enter image description here

open the SSRS and create an Image. In the Image properties you need to change the selected Image source to Database: enter image description here

Under use this field put the relevant field from your query.

and under MIME type select the image format:

enter image description here

That It!

Note:

During my small research I ran in to this MSDN requesting to avoid using IMAGE types because it will be removed in a future version of Microsoft SQL Server.

Be advise!

enter image description here

Upvotes: 1

Related Questions