Pager Properties

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

Properties

Type 

Select what the pager will control

• Table : Determines the table that is associated with this pager
• Grid : New in v7.5 - 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 : New in v9.1 - Determine the repeater that is associated with this pager

Page size 

Sets how many rows/columns are displayed per page

Placement 

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

• Free Floating - the pager is not affected by any cell changes
• Move - the pager moves when the cell it is on moves
• Move and Size - the pager moves when the cell it is on moves, and is resized when cells beneath it are resized

Layout

Sets the pager controls horizontally or vertically

• Show Texbox - determines whether the pager text is displayed ie "Page 1 of 4"

Behaviour

Name 

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

Enable 

Toggle whether the slicer is enabled. If it is not enabled, it will not restrict the output of the report.

Output 

• 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.

Web

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