Note : For this tutorial, I’m using Sales -> Batch Reports -> Sales Invoice.

 

Step 1 - Go to design and amend <SR>01 report format.

Step 2 - Add new calculated field under Sales invoice Details Collection



Data Member: Sales Invoice Details Collection

Field Type: Boolean

Name: IsPageBreak 


 

Use this formula for the Expression field:

 ([DataSource.CurrentRowIndex] % 20== 0) And ([DataSource.CurrentRowIndex] != 0)

Note : 10 means maintain 20 rows per page

 

Step 3 - Add the page break control in the report’s designer, the control should be added in the detail band: 

 

Step 4 - From the page break’s property window, set Visible behavior to No and then click the "…" button of the formatting rules: 


if your layout is different can follow as below

 

Step 5 - Formatting Rules Editor

Click “Edit Rule Sheet…” button -> click “Add a formatting rule” button: 

Define the new rule as below:

Condition: [IsPageBreak] == True

Visible: Yes

Data Member: Sales Invoice Details Collection

Name: PageBreakFormattingRule

5.  Save the report format and preview:

 

Thanks for viewing.