When and how to use progressive paging to load data in grids
Progressive paging — progressively loading rows of data in grids — provides users with a superior experience when compared with traditional paging. If you are displaying data in a repeating Grid, and the data comprises more than a single page (approximately 20 rows of data), you may want to use progressive paging.
Progressive paging limits the number of rows initially loaded in the user interface, to render the page more quickly. The clipboard is loaded with all the data during the initial load. Remaining items are loaded only when the user scrolls through the list. When a user drags the scrollbar down and then releases it, additional rows are loaded in the grid.
Unlike traditional paging, in which users can access specific pages of data using paging controls, progressive paging enables users to access the entire data set by scrolling. Users can act on the full data set; for example, dragging and dropping to re-order the list or sorting and filtering the entire list.
Progressive paging is available for all data sources, including Report Definition, and can be used with grids. It is not available for tree or tree grids.
To configure progressive paging in a repeating Grid:
- Create a repeating Grid by:
- Adding a repeating Grid layout to a section and specifying the data source; see How to add a Grid layout to a section, or
- Dragging and dropping a Report Definition rule from the Application Explorer onto a section; see Using a report definition rule as a Grid layout data source.
The Grid Repeat Layout properties panel displays.
At runtime, the grid displays with 10 rows of data, as specified in the number of Items per Page. The scrollbar appears on the right. As the user drags the scrollbar and releases, all rows above that point in the grid are loaded.
The user can scroll to access the entire data set and re-order, sort, and filter the entire list.
To view and interact with a working example of progressive paging in the UI Gallery select > User Interface > UI Gallery and then select Paging in the Repeating Layouts group.
Note: Performance with large data sets is influenced by a variety of factors including the row contents and the end-user’s system. Sorting and filtering can provide alternate ways for a user to access a specific set of rows.