How to run a report and convert it to Base64 string.

(1) Share

Report

Posted on by SG-05091051-0

163

Hi All,

We are working on on-prem Business Central , i want to create pdf of sales order using AL code. Actually i want to run my sales order report in al code then i want to convert it on base64 so after that i can send this base64 string to API.

Does anyone have any idea about this, how we can do this.

Thanks for Help.

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Suggested answer

Nitin Verma 21,812 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi,

You can try as below

var TempBlob: Codeunit "Temp Blob"; ReportInStream: InStream; ReportOutStream: OutStream; Base64Convert: Codeunit "Base64 Convert"; TempBlob.CreateOutStream(ReportOutStream); Report.SaveAs(ReportID, '', ReportFormat::Html, ReportOutStream, RecordRef); TempBlob.CreateInStream(ReportInStream); ReportInStream.ReadText(BodyText); Base64Convert.ToBase64(BodyText);

Was this reply helpful? Yes No
Verified answer

Sami Ullah 315 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
Hi,
Please try this code.

var ReportSelections: Record "Report Selections"; TempReportSelections: Record "Report Selections" temporary; TempBlob: Codeunit "Temp Blob"; Base64Convert: Codeunit "Base64 Convert"; outStreamReport: OutStream; inStreamReport: InStream; ReportUsage: Enum "Report Selection Usage"; DocumentPrint: Codeunit "Document-Print"; SourceRecordRef: RecordRef; SalesHeader: Record "Sales Header"; DocumentBase64: Text; begin // If you already have a RecordRef, you can skip the next four lines. if not SalesHeader.FindFirst() then // For testing purposes, retrieving the first record of the Sales Header. // In your real scenario, replace this with the necessary conditions. exit; SalesHeader.SetRecFilter(); // Set the filter on SalesHeader to be used for the RecordRef. SourceRecordRef.GetTable(SalesHeader); // Assign the SalesHeader record to the SourceRecordRef. ReportUsage := DocumentPrint.GetSalesDocTypeUsage(SalesHeader); // Determine the report usage based on the document type of the Sales Header. ReportSelections.FindReportUsageForCust(ReportUsage, SalesHeader."No.", TempReportSelections); // Find the appropriate report selection for the customer based on the report usage and Sales Header number. // Store the result in a temporary Report Selections record (TempReportSelections). TempBlob.CreateOutStream(outStreamReport); // Create an output stream in the TempBlob to store the generated report. ReportSelections.SaveReportAsPDFInTempBlob( TempBlob, TempReportSelections."Report ID", SourceRecordRef, TempReportSelections."Custom Report Layout Code", ReportUsage ); // Save the selected report as a PDF into TempBlob using the specified report ID, // custom report layout, and report usage. TempBlob.CreateInStream(inStreamReport); // Create an input stream from the TempBlob to read the PDF report data. DocumentBase64 := Base64Convert.ToBase64(inStreamReport, false); // Convert the report data from the input stream to a Base64-encoded string // and assign it to the DocumentBase64 variable. end;

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 102,123 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi, hope the following helps as well.

Dynamics 365 Business Central: How to import/create item picture from encoded text (Base64 String)

https://yzhums.com/39193/

Dynamics 365 Business Central: How to convert Image (item picture) to encoded text (Base64 String) via AL

https://yzhums.com/40077/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Nyakinyua 55 on at

Like
a
(1)

Report
Copy link

Link copied!

Var
VarTempBlob: Codeunit "Temp Blob";
IStream: InStream;
B64: Codeunit Base64;
FileManagement: Codeunit "File Management";
EncryptedFileName: Text;

if not FileManagement.ServerFileExists(EncryptedFileName) then
Error('The file %1 does not exist.', EncryptedFileName);

// Create an InStream from the file
FileManagement.BLOBImportFromServerFile(VarTempBlob, EncryptedFileName);

// Get the InStream from the TempBlob
VarTempBlob.CreateInStream(IStream);

// Convert the InStream to Base64
Base64 := B64.StreamToBase64String(IStream);

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 102,123 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Update: Dynamics 365 Business Central: How to save a report as encoded text (Base64 String) via AL

https://yzhums.com/56542/

Thanks.

ZHU

Was this reply helpful? Yes No
Vahid Ghafarpour 12,266 on at

Like
a
(1)

Report
Copy link

Link copied!

** Please don't forget to close up the thread here by Like and verify it as an answer if it is helpful **

Was this reply helpful? Yes No