Small and medium business | Business Central, N...

CONVERT REPORT PDF TO BASE64 USING BIGTEXT

(2) Share

Report

Posted on by CU22100733-0

281

Hi,

I want to convert a base report pdf to BASE64 string without using blob field, & while using big big text datatype only.

Plz help me with the code here

Categories:

Dynamics 365 Business Central

Microsoft Dynamics NAV

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Suresh Kulla 50,247 Super User 2025 Season 2 on at

Like (0)

Report

Are you on OnPrem or Saas version? if you are using OnPrem you can use File DataType to create Instream and then convert to base64 string.

Was this reply helpful? Yes No
Suggested answer

CU22100733-0 281 on at

Like (0)

Report

Not able to use file datatype procedure, Plz suggest something else

Was this reply helpful? Yes No
Suresh K 54 on at

Like (1)

Report

You didnt answer my question, are you on Saas or OnPrem ?

Was this reply helpful? Yes No
Suggested answer

Sami Ullah 315 Moderator on at

Like (0)

Report
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 95,748 Super User 2025 Season 2 on at

Like (1)

Report

Hi, hope the following helps.

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
CU22100733-0 281 on at

Like (0)

Report

Hello @Suresh K, I am not able to use file datatype functions as it showed that it is for OnPrem only, so I guess I have saas version

Was this reply helpful? Yes No
Gerardo Rentería Ga... 25,373 Most Valuable Professional on at

Like (1)

Report

Hi, good day
I hope this can help you, and give you some hints.

Create Base64 string of business central report - NAVwithNAV

How to Obtain Different PDF Reports of Sales Orders through Webservices - Ivan Singleton

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

Best Regards
Gerardo

Was this reply helpful? Yes No