# Check Box Input Control for Build Your Own Reports

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

×

Loading...