SSRS - Display Image in a report from an Image column Type

(0) Share

Report

Posted on by EBMRay

905

Hello,

I have a custom table in dataverse that has an Image column as a data type. I created one record for this table and uploaded a png image.

I started building the SSRS Report that is linked to that table to display the image uploaded.

Below is the issue that I am facing:

It seems that the Image column type in dataverse does not save the content of the image as base64 and to display the image in the report requires this content.

Do I have to create a "Text Area" field hidden to convert the uploaded image to base64 and make the report rely on this field? If so, how can we do it via plugins?

Can please someone provide an example of how can we convert the image to base64, set the results in the text area field using the plugin, and when the plugin should be triggered?

Any help is highly appreciated.

Best regards,

EBMRay

I have the same question (0)

All responses (4)

Answers (1)

EBMRay 905 on at

Like (0)

Report

Hello ,

I would highly appreciate your support for this issue.

Thank you!

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report
Hi EBMRay,

It's really a hard work and took me a long time. Finally, works out. Please follow the steps:

1. Create a field to store the base64 string.(Please Maximize the field length.)

2. Create an onchange event on your Image field.

Code is like this:

var validator = false; async function changeImage(executionContext){ if(validator){ return; } var formContext = executionContext.getFormContext(); var image = formContext.getAttribute("cr1bc_companylogo").getValue(); formContext.getAttribute("new_longbase64").setValue(""); if(image){ var base64 = await toBase64(image["_file"]); formContext.getAttribute("new_longbase64").setValue(base64.replace("data:image/jpeg;base64,","")); validator = true; } } const toBase64 = file => new Promise((resolve, reject) => { const reader = new FileReader(); reader.readAsDataURL(file); reader.onload = () => resolve(reader.result); reader.onerror = error => reject(error); });

3. Open your form and change the image. The 'LongBase64' would auto filled.

4. Create a SSRS report with the following FetchXML:

5. Don't Add the Base64 String field to your report.

6. Insert a column and then insert a image. Its setting like this:

Expression: =System.Convert.FromBase64String(Fields!new_longbase64.Value)

Note: please change the MiMe type.

Preview:

Was this reply helpful? Yes No
EBMRay 905 on at

Like (0)

Report

Hello ,

Thank you so much for spending your time and providing a detailed step-by-step to achieve this requirement.

I will follow your steps and get back to you if I encounter any issues.

Your help is greatly appreciated!!

Best regards,
EBMRay

Was this reply helpful? Yes No
Suggested answer

JasonMcandrew 40 on at

Like (0)

Report

Thanks for your help with this, I've been looking to implement product images in our quote report.

My findings were that the EntityImage column is in fact Base64 encoded already. The problem is the data type "Image" is not supported when adding EntityImage in the FetchXML of my Dataset in Visual Studio.

I created a new text column and used a simple flow to copy the value from EntityImage into the new column. I can now include the text column in my report using the method System.Convert.FromBase64String() which is working perfectly.

Was this reply helpful? Yes No