Check boxes allow the user to select one or more items from a set of items that you configure.
Example
This image is an example of a check box input in a report:
Settings
To display a series of check boxes based on the data from the jobstatus field, configure the following settings on the Edit Report Input dialog box:
Setting |
Selection |
---|---|
Input Variable |
The name you will use as a parameter in the report query. |
Display Name |
Then name that will appear as a label for the input in the report. |
Input Variable Type |
String |
Input Control Type |
CheckBox |
Allow MultiSelection |
Selected |
Required |
Optional |
Default Value |
Success |
Values |
DataSet |
DataSet |
The data set you created for this input |
Value Field |
jobstatus |
Label Field |
jobstatus |
The following image is an example of the configured settings.
Example Query
If you configured multiselection for a check box, then configure the associated parameter as Multi. Configure the following settings on the Edit Data Set dialog box:
Setting |
Selection |
---|---|
Parameter |
Input variable that you configured in the Edit Report Input dialog box. |
Type |
String |
Multi |
Selected |
Required |
Cleared |
Value |
=input.jobStatus |
The following image is an example of the configured settings.
Then, add the parameter as part of a where clause in the report query in the Query box on the Edit Data Set dialog box.
where jobstatus in (select jobStatus from @jobStatus)
The following image is an example of the configured settings.
Associated Input Variables
-
Boolean
-
Decimal
-
Integer
-
String