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)

Suggested answer

Nitin Verma 21,788 Moderator on at

Like (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 (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 98,128 Super User 2026 Season 1 on at

Like (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 (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 98,128 Super User 2026 Season 1 on at

Like (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,216 Super User 2026 Season 1 on at

Like (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