How to set Pagination to my report

[Ahmed]

Hi , 

My report datasource retrieve many records (may be millions) and I want to paginate them to show only 10 records for example but always it shows data as 1 page with all data and I can not find any configuration in my report designer to handle this 

 

Thanks

[Todor]

Hello Ahmed,

You may introduce groups to your Table/List/Crosstab or to the Report itself. Then, you would be able to use the PageBreak property of the corresponding groups (for Table groups) or Group Header/Footer sections (for Report groups). Here are the relevant articles:

• How to Add groups to Table item and Crosstab item
• How to Add groups to Report
• Paging and Keep Together

As a grouping criteria, you may use an Integer indexing field of the data and an Expression like the following:

=Fields.Index / 10

Note that the division should be an Integer division in order to generate a separate group, for each group of ten data rows.

Regards,
Todor
Progress Telerik