Skip to content

CREPORTSQLPAGER

The CREPORTSQLPAGER formula is used to show a full or partial paging control to the user in a Published Report as a way of allow them to navigate through the keys of an EditableTable as well as create new records or edit / delete existing records.

This control will inherit the font size and colour formatting from the cell.

Syntax

CREPORTSQLPAGER (EditableTable, OutputRange, SourceKeyWhereClause, OrderByProperties)

Arguments

EditableTable

(Required)

Specify the name or id of the Editable Table you want to navigate through

OutputRange

(Required)

Specify the range where you want to write the keys the pager has selected. The number of cells in the range will determine the page size that the Pager uses.

SourceKey

Specify the source key to use when using Edit or Delete actions.

WhereClause

Specify the where clause to pass the Editable Table to restrict the records to navigate through.

This will be “AND” to any default where clause that the Editable Table already has defined

OrderBy

Specify the column or list of columns (separated by a comma) to use to order the result list

This will override any default order by the the Editable Table already has defined

Properties

Specify the set of properties used to configure the behaviour of this pager.

Use the helper formula CREPORTSQLPAGERPROPERTIES

Usage Scenarios

This formula is used as a part of building an input form with CGETSQL or as a paging control for a CREFLEXTABLE.