In Microsoft Dynamics 365 Business Central, you can create a report that generates one page per record in the dataset. This is often referred to as a “one report per page” scenario. To achieve this, you’ll typically use the RDLC (Report Definition Language Client-Side) report designer, which is the default reporting tool in Business Central. Here are the general steps to create such a report:
Step 1: Insert table in a report.
Step 2: Add a field from the dataset from which you want your report to look distinct on each page, and then add a group in a group add Adjacent above.
Step 3: In the above picture, new row has created the row, which is above and below adjacent group,
delete those two rows as shown below picture.
Step 4: Then merge the adjacent group row.
Step 5: After merging the row insert Rectangle in that row.
Step 6: Now add whatever in your report that you want to display, I have taken the example of Sales Order report.
Step 7: After inserting all the data and deploying, this is how it looks on Business Central, as shown in below picture.
Now, we can see that our data has been separated by the Sales order no. As I have grouped by Sales Order No.
Step 8: Now to show that data on separate pages, in the row group there is group present which we have created, click on that group then group properties, there is open option as Page Break, and you just checked those check boxes as shown in below images.
This is how our reports look now, one report on one page.