This section introduces pagination functions used for report making by listing their descriptions, syntax, parameters, return values and options, and giving related examples.
Description:
Compute the number of cells defined by cellExp on the current page after pagination. Note: this function is only valid on a paginated report.
Syntax:
pccount({cellExp})
Parameter:
|
cellExp |
An expression |
Return value:
Total number of cells specified by cellExp on the current page
Example:
Example 1: pccount(A2{}) Return the number of all cells expanded from A2 inclusive on the current page
Description:
Get the total number of pages. Note: this function is only valid on a paginated report.
Syntax:
pcount()
Return value:
The page count
Option:
|
@x |
Get the number of pages in a horizontally paginated page table |
|
@y |
Get the number of pages in a vertically paginated page table |
Example:
Example 1: pcount() Return the number of pages in the whole page table
Example 2: pcount@y() Return the number of pages in a vertically paginated page table
Example 3: pcount@x() Return the number of pages in a horizontally paginated page table
Description:
Compute the sum of all cells specified by cellExp on the current page after pagination. Note: this function is only valid on a paginated report.
Syntax:
pcsum({cellExp})
Parameter:
|
cellExp |
An expression |
Return value:
Sum of all cells specified by cellExp on the current page
Example:
Example 1: pcsum(A2{}) Return sum of all cells expanded from A2 inclusive on the current page
Description:
Get number of the current page. Note: this function is only valid on a paginated report.
Syntax:
pno()
Return value:
Number of the current page
Option:
|
@x |
A page number in a horizontally paginated page table |
|
@y |
A page number in a vertically paginated page table |
Example:
Example 1: pno() Return number of the previous page in the whole page table
Example 2: pno@y() Return number of the previous page in the vertically paginated page table
Example 3: pno@x() Return number of the previous page in the horizontally paginated page table
Description:
Display the total number of pages in a large report.
Syntax:
_pageCount_
Return value:
Total page count in a large report
Example:
Example 1: _pageCount_ Display total number of pages in the cell holding expression _pageCount_ after preview of the large report
Description:
Display number of the current page of a large report.
Syntax:
_pageNo_
Return value:
Number of the current page of a large report
Example:
Example 1: _pageNo_ Display number of the current page in the cell holding expression _pageNo_ after preview of the large report