CREPORTSQLSELECTORPROPERTIES¶
The CREPORTSQLSELECTORPROPERTIES formula is a helper formula that allows you to set the behaviour of a CREPORTSQLSELECTOR function.
Syntax
CREPORTSQLSELECTORPROPERTIES (AutoCalc, MultiSelect, DisplayColumnSeparator, ValueSeparator, AllowClearSelection, ListSizeLimit)
Arguments¶
AutoCalc : boolean
¶
Specify whether or not to automatically calculate the report when a value is selected from this control.
Default value: true
MultiSelect : boolean
¶
Specify whether or not this control acts as a multiple selection control, allowing the user to select 1 to many values, with the keys of those selections being stored in the output range.
Default value: false
DisplayColumnSeparator : string
¶
Specify the separator to use, where multiple columns are specified as display columns.
Default value: " "
(one space)
ValueSeparator : string
¶
Specify the separator to use where multiple values are selected by the user (when the control is in multi-select mode) in order to delineate the selected keys
Default value: ,
(comma)
AllowClearSelection : boolean
¶
Specify whether or not to show the Clear Selection
action as a part of the control
Default value: true
ListSizeLimit : number
¶
Specify the maximum number of items to return to the list at any one time.
Default value: 100