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
;Ignore pager on save to Excel :When the published report is saved back to Excel, this determines whether the pager is ignored
+
 
 +
;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.