How to set Print Count/ Page Break Item in Optimum

Created by Cheng Kah Poh, Modified on Mon, 28 Mar, 2022 at 9:32 AM by Amanda Wong Po Yi

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 : 20 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.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article