# 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:

##### 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

×

Loading...