Splitting Data on report Dynamically

[Tom]

If I have a table on a report that I want to be filled with lets say 10 rows but if the data source goes over that amount I want to move the remainder of the data to another control on a different page. Is that possible? The idea is somewhat like and overflow but to a different location.

Thank You

[Stef]

Hello Tom,

The Table item does not support page breaks. It is a feature considered for implementation you can vote for on our feedback portal - Page Break in Table or TableGroup.

Instead I can suggest you the following:

1. Use the report's section directly to visualize data (use the Band Wizard). Report sections support PageBreak. For more details check Conditional Page Breaks, where the expression would be like:
   

   = IIF(RowNumber()%10=0, PageBreak.Before, PageBreak.None)

2. Re-organize data and include a field that can be used to group data in chunks of 10 records. Bound the report to the data and add a group in the report based on that field. Then place a Table item in the GroupHeaderSection and bind the Table item via expression like:
   

   Property path: DataSource
   Expression:  = ReportItem.DataObject

   Finally, set the GroupHeaderSection.PageBreak property.
   
   More details about the ReportItem.DataObject can be found in How to use the ReportItem.DataObject property in expressions.

Let us know if you need any further help. Please feel free to open a support ticket and send us an example with the report and sample data to test it locally.

Regards,
Stef
Telerik