Data Paging

• Jun 16, 2022
• 2 minutes to read

By default, ASPxPivotGrid automatically splits content across multiple pages and provides end-users with the capability to navigate through the Pivot Grid’s data using pager. The pager allows you to navigate through data by selecting the required page number or using the navigation buttons.

Pager Settings

The ASPxPivotGrid.OptionsPager property returns the PivotGridWebOptionsPager object, exposing the following settings related to the pivot grid’s pager.

• The Pager is automatically displayed when the ASPxPivotGrid content does not fit on one page. To specify whether the pager is always displayed, set the PivotGridWebOptionsPager.AlwaysShowPager property to true. To disable the pager, set the PagerSettingsEx.Visible to false. In this case, the ASPxPivotGrid control will display all of its records on one page and the control’s height will depend on the number of displayed records.
• To specify the maximum number of rows displayed on a page, use the PivotGridWebOptionsPager.RowsPerPage property. In the virtual scrolling mode, you can specify the maximum number of columns displayed on a page using the PivotGridWebOptionsPager.ColumnsPerPage property.
• To specify the currently selected page, use the PivotGridWebOptionsPager.PageIndex property. In the virtual scrolling mode, you can specify the index of the active column page using the PivotGridWebOptionsPager.ColumnPageIndex property.
• The PivotGridWebOptionsPager.PagerAlign property specifies the horizontal alignment within the pivot grid. Use the PagerSettingsEx.Position property to control the pager’s position in the ASPxPivotGrid: at the control’s top, bottom, or both.