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:

check_box

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.

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

check_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 jobstatus in (select jobStatus from @jobStatus)

The following image is an example of the configured settings.

check_box_multi_code

Associated Input Variables

  • Boolean

  • Decimal

  • Integer

  • String

Loading...