CREPORTSQLSELECTORPROPERTIES

The CREPORTSQLSELECTORPROPERTIES formula is a helper formula that allows you to set the behaviour of a CREPORTSQLSELECTOR.

Syntax

CREPORTSQLSELECTORPROPERTIES (AutoCalc, MultiSelect, DisplayColumnSeparator, ValueSeparator)

Arguments

AutoCalc

Specify whether or not to auto calculate the report when a user selects a value from this control.

Default value: true

MultiSelect

Specify whether or not this control acts as a multiple selection control allowing the user to select 1 to many values and the keys of those selections are stored in the output range.

Default value: false

DisplayColumnSeparator

Specify the separator to use, where multiple columns are specified as display columns, to delineate them.

Default value: One space

ValueSeparator

Specify the separator to use where multiple values are selected by the user when the control is in multi-select mode to delineate the selected keys

Default value: Comma