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

Printing report for many records at the same time

(0) Share

Report

Posted on by MarceloSanchez

Hi! I created report and RDLC layout. In the next step I want to print reports for more than one record at the same time (like Purchase Invoice printing with filtr on a few documents - for every document - new page occurs report).
How can I do this? I want the same behaviour - for every record - new page in printed report.

I pass on table records to report X and it works correctly - 'OnAfterGetRecord' for dataitem occurs X times. But report is printed only for first record.

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

You need to loop through the records and put your report processing into a repeat statement.

Read more about the repeat statement here:

learn.microsoft.com/.../devenv-al-control-statements

Was this reply helpful? Yes No
Maxim Rylev 75 on at

Like (0)

Report

Can you expand your answer?

Where is needed to loop through records? If table with many records is passed to report (and trigger many times dataitem in OnAfterGetRecord trigger) - it is not this looping?

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,111 Moderator on at

Like (0)

Report

That really depends on how your report is built.

Often when you want to print many records with a page shift in between you really want to process it as separate report executions.

That is what the use of a repeat loop will do for you.

A good example is an invoice or an order confirmation. You should loop through those document headers and print them one by one. Instead of getting a multi page report.

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi, I think you can refer to the standard report.
for example, Standard Sales - Order Conf. (1305)

Source Code and layout file:

[View:/cfs-file/__key/communityserver-discussions-components-files/758/StandardSalesOrderConf.Report.al]

[View:/cfs-file/__key/communityserver-discussions-components-files/758/StandardSalesOrderConf.docx]

[View:/cfs-file/__key/communityserver-discussions-components-files/758/StandardSalesOrderConf.rdlc]

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No