List box lists allow the user to select an item from list of data that you configure.
Example
This image is an example of a list box input in a report:
Settings
To display a list box in your report, 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 |
ListBox |
|
Allow MultiSelection |
Selected |
|
Required |
Optional |
|
Default Value |
Windows File System |
|
Values |
DataSet |
|
DataSet |
The data set you created for this input |
|
Value Field |
idataagent |
|
Label Field |
idataagent |
The following image is an example of the configured settings.
Example Queries
You can add a list with multiple values that has a default value selected or a list with no default value selected.
Lists with a Default Value
If you configured multiselection for a list box, then configure the associated parameter as Multi. Configure the following settings on the Edit Data Set dialog box to make a list with a default value selected:
|
Setting |
Selection |
|---|---|
|
Parameter |
Input variable that you configured in the Edit Report Input dialog box. |
|
Type |
String |
|
Multi |
Selected |
|
Required |
Cleared |
|
Value |
=input.agent |
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 idataagent in (select agent from @agent)The following image is an example of the configured settings.
Lists with No Default Value
If you configured multiselection for a list box, then configure the associated parameter as Multi. Configure the following settings on the Edit Data Set dialog box to make a list with no default value selected:
|
Setting |
Selection |
|---|---|
|
Parameter |
Input variable that you configured in the Edit Report Input dialog box. |
|
Type |
String |
|
Multi |
Selected |
|
Required |
Cleared |
|
Value |
=input.agent |
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 (iDataAgent in (select agent from @agent) or not exists(select agent from @agent))The following image is an example of the configured settings.
Associated Input Variables
-
Boolean
-
Decimal
-
Integer
-
String