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

Answered

Add action to list page to print custom report

(0) Share

Report

Posted on by Anita75

1,165

Hi All,

I have created an action on Posted sales invoice to print a different format than than default and its working as below:

action("Print Packing Slip")

{

Promoted = true;

PromotedCategory = Process;

Caption = 'Print Packing Slip';

Ellipsis = true;

Image = Print;

PromotedIsBig = true;

ApplicationArea = All;

ToolTip = 'Print Packing Slip Based On Invoice';

//Visible = NOT IsOfficeAddin;

trigger OnAction()

var

SalesRec: Record "Sales Invoice Header";

Myreport: Report MyPostedInvPackingSlip;

begin

;

Clear(SalesRec);

SalesRec := rec;

SalesRec.SetRecFilter;

Myreport.SetTableView(SalesRec);

Myreport.RunModal();

end;

}

Now I want to do the same from posted invoice list page. Not sure ho to select a record and change print layout on a list page

thanks

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Mohana Yadav 60,993 Super User 2025 Season 2 on at

Like (0)

Report

I am not sure what exactly do you mean by "How to select a record".

we can select a line in list page also and actions will be performed on that record/line.

Was this reply helpful? Yes No
Suggested answer

JAngle 133 on at

Like (0)

Report

Take this as an example:

action(Print)

{

ApplicationArea = Basic, Suite;

Caption = '&Print';

Ellipsis = true;

Image = Print;

Promoted = true;

PromotedCategory = Category7;

ToolTip = 'Prepare to print the document. A report request window for the document opens where you can specify what to include on the print-out.';

Visible = NOT IsOfficeAddin;

trigger OnAction()

var

SalesInvHeader: Record "Sales Invoice Header";

begin

SalesInvHeader := Rec;

CurrPage.SetSelectionFilter(SalesInvHeader);

SalesInvHeader.PrintRecords(true);

end;

}

Just replace the last line with a line for your desired report like:

var

CustomerRec: Record Customer;

SomeReport: Report "Salesperson - Sales Statistics";

begin

SomeReport.SETTABLEVIEW(CustomerRec);

SomeReport.RUN;

end;

Layout will be whatever is set in the report layout selection table

Was this reply helpful? Yes No
Anita75 1,165 on at

Like (0)

Report

Close but the selected report number didn't come through so chnage it slightly

begin

SalesInvHeader := Rec;

CurrPage.SetSelectionFilter(SalesInvHeader);

MYReport.Run();

;

end;

Was this reply helpful? Yes No
Anita75 1,165 on at

Like (0)

Report

Actually this code didn't work ...selected row invoice number is not passing to request page

Was this reply helpful? Yes No
Verified answer

Mohana Yadav 60,993 Super User 2025 Season 2 on at

Like (0)

Report

you have to use SetSelectionFilter.

Was this reply helpful? Yes No
Anita75 1,165 on at

Like (1)

Report

Code worked I was overthinking...

SalesInvHeader := Rec;

CurrPage.SetSelectionFilter(SalesInvHeader);

MyReport.SETTABLEVIEW(SalesInvHeader);

MYReport.Run;

But the limitation is it only works when selecting one row on the list page..Is there a way to get this work when selecting mutiple rows?

Was this reply helpful? Yes No
BchM 92 on at

Like (0)

Report

Hi, did you find any way to do it with multiple rows?

Was this reply helpful? Yes No

Join the conversation

Community site session details

Add action to list page to print custom report

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

Add action to list page to print custom report

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates