List Box Input Control for Build Your Own Reports

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:

list_box

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.

list_box_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.

list_box_parameter

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.

list_box_code

Lists with No Default Value

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.

list_box_parameter

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.

list_box_code_no_default_value

Associated Input Variables

Boolean
Decimal
Integer
String