Troubleshooting: Repeat Grid with Enable Paging does not display all rows
When a Repeat Grid has Enable Paging checked, and the grid source is a Report Definition that also has Enable Paging checked, the grid sometimes does not display all of the records you expect to see.
When the Report Definition form, the User Interactions tab, has Enable Paging checked, the maximum number of records that are retrieved and displayed on the Repeat Grid is restricted. This behavior is irrespective of the Enable Paging option on the Repeat Grid layout element itself.
To ensure that the correct number of rows specified in the Report Definition Data Access tab is retrieved, go to the Report Definition User Interactions tab and uncheck the Enable Paging option.
Starting with PRPC 6.2x, you cannot have both options, Enable Paging and Maximum Number Of Rows To Retrieve, enabled at the same time; this is restricted by design.
The following screens illustrate the scenario that causes the problem. The last screen shows the Enable Paging option that you need to uncheck to display all rows specified for the Repeat Grid.
When and how to configure paging in reports
Report Definition form, Completing the User Interactions tab
How to add a Grid layout to a section
Using a report definition rule as a data source for a Grid layout
Published February 24, 2014 — Updated October 2, 2015