[]
DEMOS DOC DESIGNER API
DOWNLOAD
(Showing Draft Content)

Get Pagination Info

Pagination details in a report can be retrieved with the R.CURRENTPAGE and R.PAGESCOUNT functions, which work at both the report level and the group level.

Note:

Support for group‑level pagination is available starting from v19, and only available for row pagination in Master-Detail reports.

Pagination Functions

  • R.CURRENTPAGE(use_grouped_context)

    • Description: Returns the current page number.

    • Parameter: use_grouped_context (optional, boolean, default false)

      • If true, returns the current page number within the current Master-Detail group.

  • R.PAGESCOUNT(use_grouped_context)

    • Description: Returns the total page count.

    • Parameter: use_grouped_context (optional, boolean, default false)

      • If true, returns the total page count within the current Master-Detail group.

Examples

Get Global Pagination Info

The following example displays the current page number together with the total page count.

// Formula of E6
=CONCAT("Page ",R.CURRENTPAGE()," of ",R.PAGESCOUNT())

image

The orders report generated from the above TemplateSheet is shown below.

image

Get Group Pagination Info (Master-Detail only)

This example shows how to display both the overall report pagination and the pagination within each group.

// Formula of E5
=CONCAT("Page ",R.CURRENTPAGE()," of ",R.PAGESCOUNT())
// Formula of E6
=CONCAT("Page ",R.CURRENTPAGE(TRUE)," of ",R.PAGECOUNT(TRUE))

image

The orders report generated from the above TemplateSheet is shown below.

image