Pagination functions

Read(359) Label: pagination,

This section introduces pagination functions used for report making by listing their descriptions, syntax, parameters, return values and options, and giving related examples.

pccount()

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

pcount()

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

pcsum()

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

pno()

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

_pageCount_

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

_pageNo_

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