How to limit table items per page?

[Anders]

I want to limit table items display in per page, such as 4, I used RowNumber(), but it had no effect.

[Neli]

Hello Anders,

Basically, the Value of the PageBreak can be Before/ After/ None/ BeforeAndAfter. Try to change the Expression to:

=IIf(RowNumber() Mod 4 = 0, "After", "None")

The attached report demonstrates the approach. 

Regards,
Neli
Progress Telerik

[Anders]

Thanks for your help, Neli, but it's not usable when the detail section with two data source, such as a main source and a detail source. When a table is used in the detail section to display detail source, the expression IIf(RowNumber() Mod 4 = 0, "After", "None") has no effort.

[Neli]

Hello Anders,

In such scenarios, we recommend adding a field in the datasource (for example Group) and based on it to set grouping in the table. Then set the Page Break property of the group to After. All required steps are demonstrated in the attached video and report.

If you wish to avoid the lines which indicate that the table is continued to the next page, check Hide table borders extending to the next page KB article.

Regards,
Neli
Progress Telerik

[Anders]

Thank you.