How to print image on RDL/DOCX report format with AL

(1) Share

Report

Posted on by Redgren

I have added a new table that stores a User ID and Image with the intention of being able to

print the image of the user(s) on certain documents.

On the report object I managed to add the dataset correctly, I assume, as follows:

I then used the table control in my rdl design to display the values, but I get the following on the image field for all entries:

The field data type is BLOB and SubType is Bitmap. How can I make it work with either RDL or WordLayout.

regads,

Lord Rapha

I have the same question (0)

All responses (8)

Answers (0)

Redgren 80 on at

Like (1)

Report

RE: How to print image on RDL/DOCX report format with AL

Thank you all (Amit, Zhu & Corella) for your submissions. The information from all responses helped me achieve what I wanted.

Was this reply helpful? Yes No
Suggested answer

Steven Renders 5,658 Moderator on at

Like (0)

Report

RE: How to print image on RDL/DOCX report format with AL

This is indeed how to do it, however the Convert.ToBase64String and Convert.FromBase64String are not required. They date back from the time the images were put in a hidden textbox on the body, and so they needed to be converted to text and then back to image. Then from the body they could be referenced on the header/footer.

If you use images in the body, they don't need to be converted to text. And if you need an image on the report header/footer, simply put it on the first/last line of the dataset and reference it in the image control.

Was this reply helpful? Yes No
Suggested answer

Robyn2018 Most Valuable Professional on at

Like (1)

Report

RE: How to print image on RDL/DOCX report format with AL

Hi,

In your case:

dataitem("SGP Signature";"SGP Signature")

{

...

column(user_signature:"user signature") {includecaption = true;}

trigger OnAfterGetRecord()

begin

"SGP Signature".calcfields("User signature");

end;

}

Don't forget to help the community by verifying the answer or at least like the suggestion if it did help in any way. It will let others know that the topic has verified answer and was beneficial to you.

Roberto Corella

Business Central developer

blog: https://blog.msdyn365bc.es
youtube channel: www.youtube.com/.../UCeIS0DjQXp4R-aWY20PSVyg
Linkedin: www.linkedin.com/.../
Twitter: https://twitter.com/rccorella

Was this reply helpful? Yes No
Redgren 80 on at

Like (0)

Report

RE: How to print image on RDL/DOCX report format with AL

Hi, thanks for the reply. How can I do this "Calculation" on nested dataitems?

Was this reply helpful? Yes No
Redgren 80 on at

Like (0)

Report

RE: How to print image on RDL/DOCX report format with AL

Hi, thanks for the reply. The challenge is on applying this "Calculation" on nested dataitems. How can I do it.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 92,067 Super User 2025 Season 2 on at

Like (0)

Report

RE: How to print image on RDL/DOCX report format with AL

Hi, here's an early example of adding a company seal to a report that I tested.

https://yzhums.com/1958/

Hope this helps.

Thanks.
ZHU

Was this reply helpful? Yes No
Suggested answer

Robyn2018 Most Valuable Professional on at

Like (1)

Report

RE: How to print image on RDL/DOCX report format with AL

Hi,

Remember you must calculate the blobs in the AL file:

After this, in the rdlc you can the image control and select, database as image source:

In the field expression:

I hope this help you.

Don't forget to help the community by verifying the answer or at least like the suggestion if it did help in any way. It will let others know that the topic has verified answer and was beneficial to you.

Roberto Corella

Business Central developer

blog: https://blog.msdyn365bc.es

youtube channel: www.youtube.com/.../UCeIS0DjQXp4R-aWY20PSVyg

Was this reply helpful? Yes No
Suggested answer

Amit Baru 3,035 on at

Like (1)

Report

RE: How to print image on RDL/DOCX report format with AL

Hi,

Pls refer link for the above query.

erpconsultors.com/.../

Regards

Amit Sharma

www.linkedin.com/.../

Pls press Yes if information is useful.

Was this reply helpful? Yes No