CREPORTSQLSELECTOR

The CREPORTSQLSELECTOR formula, when used in a Published Report, this will show a control that will give you a searchable list of records to select from.  You configure this control to work as a single record selector or configure it to allow multiple selections.

The selected key(s) or the configured ReturnColumn from the Editable Table will be returned to the output cell and where multiple records are selected, they will delimited by default with a comma or if configured, your designated delimiter.

Syntax

CREPORTSQLSELECTOR (EditableTable, OutputRange, DisplayColumns, WhereClause, Properties)

Arguments

EditableTable

(Required)

Specify the name or id of the Editable Table you want to show records from.

OutputRange

(Required)

Specify the range where you want to write the key(s) of the items that have been selected by the user. If the range is a single cell, all the keys selected will be put into that cell with a separator, if the range contains multiple cells, then the keys will be filled into that range by column by row.

Use the helper formula CREPORTSQLSELECTORPROPERTIES to set the key separator, the default separator is a comma.

DisplayColumns

(Required)   Specify the comma separated column/field names to use as the display for the list.

Use the helper formula CREPORTSQLSELECTORPROPERTIES to set the separator, the default separator is a space

ReturnColumn

Specify the column that will act as the key for selections made. If no return column is specified, the Key column defined in the Editable Table definition is used.

WhereClause

Specify the where clause to pass the Editable Table to restrict the records to select from.

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

OrderBy

Specify the column or list of columns with either ASC or DESC specified (separated by a comma) to use to order the result list. If not specified, the Display Columns will be used.

Properties

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

Use the helper formula CREPORTSQLSELECTORPROPERTIES