Skip to content

CREFLEXTABLE

The CREFLEXTABLE formula is used to build dynamically sizing reports, or “Reflex reports”, based on an Editable Table definition.

Syntax

CREFLEXTABLE (EditableTable, ColumnsDefinition, WhereClause, OrderBy, DataRange, FormatRange, LeftOffset, TopOffset, RightOffset, BottomOffset, MaxRows, MaxColumns, NullsAs)

Arguments

EditableTable

(Required)

Specify the name or id of the EditableTable to use.

ColumnsDefinition

(Required)

Specify the range that holds the column definitions for how this Editable Table will be output.

See below details on how this range works.

WhereClause

(Required)

Specify the where clause to append to the existing Editable Table where clause if it exists.

OrderBy

(Required)

Specify the table columns you want to order by.

Data Range

(Required)

Specify the data range of the report.

Format Range

(Required)

Specify the format range of the report.

Left Offset

Specify the left offset of the report.

Default value: 0

Top Offset

Specify the top offset of the report.

Default value: 0

Right Offset

Specify the right offset of the report.

Default value: 0

Bottom Offset

Specify the Bottom Offset of the report.

Default value: 0

Max Rows

Specify the max row number of the report. -1 represents unlimited rows.

Default value: -1

Max Columns

Specify the max column number of the report. . -1 represents unlimited columns.

Default value: -1

Nulls As

Specify the value which can replace null.

Default value: 0

Columns Definition Range

This range is a multi-column, multi-row range that has the following style:

  • ROW #1 - Field Names or Formula to fill down
  • ROW #2 - Whether the Lookup type field in this column will return the key or description to the result set
    • Default (TRUE or empty) is to return the Description from the lookup table
    • FALSE to return the key

In the first row, where the value matches a valid column name from the Editable Table, the data for that column will be returned.  Where it does not match, it will be deemed to be a formula and will be filled down in its relative position in the resulting data, just like the way the padding ranges work with formula.

e.g.