Report.SaveAsPdf saves first report from the Sales Orders

(0) Share

Report

Posted on by SINTEGRA

Hello dear community!

Having a problem using SaveAsPdf function, don't know what's missing.

So I added trigger OnAfterAction in Post Action in Sales Order.

trigger OnAfterAction()

var

PdfFilePath: Text;

PdfFileName: Text;

begin

PdfFileName := Rec."No." + '_' + Format(Rec."Posting Date") + '_' + Rec."Sell-to Customer Name";

PdfFilePath := 'C:\DL\' + PdfFileName + '.pdf';

Report.SaveAsPdf(ReportID, PdfFilePath);

end;

PdfFileName is being generated correctly, it gets the right No., Posting Date and Sell-to Customer Name from the order, but Report.SaveAsPdf function saves report from the first Sales Order in the list.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Nitin Verma 21,708 Moderator on at

Like (0)

Report
Hi,

You can try this way

var DocRef: RecordRef; FldRef: FieldRef; Cust: Record Customer; DocRef.GetTable(Cust); FldRef := DocRef.Field(Cust.FieldNo("No.")); FldRef.SetRange(Cust."No."); if DocRef.FindFirst() then begin CustomerBalancetoDate.InitializeRequest(false, false, false, YourDate); CustomerBalancetoDate.SetTableView(Cust); CustomerBalancetoDate.SaveAs('', ReportFormat::Pdf, Outstrebody, DocRef); end;

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,697 Super User 2025 Season 2 on at

Like (2)

Report

Hi, It looks like you are using the On-Pre version. Please try the code below.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/report/report-saveaspdf-method

Hope this helps.

Thanks

ZHU

Was this reply helpful? Yes No
SINTEGRA 12 on at

Like (2)

Report

Thank you Yun Zhu :) Didn't get right that Optional parameter, now I understand it. My question solved.

Was this reply helpful? Yes No