Pager properties

This form has several properties that adjust how the table pager behaves.

Select what the pager will control:

• Table: Determines the table that is associated with this pager.
• Grid: Paging for grids. Determines the grid that is associated with this pager. You can select whether the paging is on grid rows or columns.
• Repeater: Determine the repeater that is associated with this pager.

Sets how many rows/columns are displayed per page.

Controls how the pager control behaves when cells around it are resized.

• Free-floating: The pager isn't affected by any cell changes.
• Move: The pager moves when the cell it's on moves.
• Move and Size: The pager moves when the cell it's on moves, and is resized when cells beneath it are resized.

Sets the pager controls horizontally or vertically.

Show Textbox: Determines whether the pager text is displayed, i.e. "Page 1 of 4".

Give the pager a name. This is needed if using it in conjunction with, for example, XL3SetProperty.

Toggle whether the slicer is enabled. If it isn't enabled, it won't restrict the output of the report.

• Page number: The number of the page currently being shown.
• Page count: The total number of pages.
• Page size: The number of rows/columns returned in each page.
• Total count: The total number of rows/columns.
• Current row: The number of the first row/column in the current page.

Determine whether the pager is ignored on downloading the published report to Excel or pdf.