This is a migrated thread and some comments may be shown as answers.

How to limit table items per page?

4 Answers 50 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Anders
Top achievements
Rank 1
Anders asked on 25 Mar 2020, 08:34 AM
I want to limit table items display in per page, such as 4, I used RowNumber(), but it had no effect.

4 Answers, 1 is accepted

Sort by
0
Neli
Telerik team
answered on 27 Mar 2020, 12:30 PM

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

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
0
Anders
Top achievements
Rank 1
answered on 28 Mar 2020, 08:44 AM
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.
0
Neli
Telerik team
answered on 01 Apr 2020, 01:33 PM

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

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.
0
Anders
Top achievements
Rank 1
answered on 02 Apr 2020, 05:20 AM
Thank you.
Tags
Report Designer (standalone)
Asked by
Anders
Top achievements
Rank 1
Answers by
Neli
Telerik team
Anders
Top achievements
Rank 1
Share this question
or