| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Pager Properties"
(Created page with "This form has several properties that adjust how the table pager behaves. ;Table :Determines the pager that is associated with this pager ;Page size :Sets how ...") |
|||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
This form has several properties that adjust how the [[Tables#Paging|table pager]] behaves. | This form has several properties that adjust how the [[Tables#Paging|table pager]] behaves. | ||
| − | ;Table :Determines the pager that is associated with this pager | + | ==Properties== |
| − | ;Page size :Sets how many rows are displayed per page | + | ;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 [[Repeaters|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 | ;Placement :Controls how the pager control behaves when cells around it are resized | ||
::* '''Free Floating''' - the pager is not affected by any cell changes | ::* '''Free Floating''' - the pager is not affected by any cell changes | ||
::* '''Move''' - the pager moves when the cell it is on moves | ::* '''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 | ::* '''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. | ||
| + | |||
| + | |||
| + | |||
| + | [[Category:Tabular Reporting]] | ||
| + | [[Category:Relational Reporting]] | ||
Latest revision as of 14:22, 29 June 2018
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.
