Drop-down check box enables multi-value query

1) Expected effect

In actual use, users can select multiple items through the drop-down check box, and the effect is as shown in the picture below:

2) Implementation roadmap

Use drop-down check box widgets and set parameter conditions and filtering conditions to achieve multiple application scenarios.

1.Preparing data

Create a regular report, add database query ds1: SELECT * FROM ModelSalesData, as shown below:

2.Report design

Design the report style and drag the corresponding fields into the cell, as shown below:

3.Setting template parameters

Select create template Parameter, the parameter name is: type, as shown below:

4.Setting the drop-down check box widget

1)Edit the parameter pane, select add all, and select "Drop-down check box widgets", as shown below:

2) ClickData Dictionary, select Data Query for type setting, select ds1 for dataset, and select Category for both actual value and display value, as shown below:

5.Setting filter criteria

Click A2 cell, select filter, select the Category of the optional column, the operator is equal to, select the parameter $type, and click "Add", as shown below:

6.Effect preview

1) PC

Save the template and click Pagination Preview, the effect is as shown below:

2)Mobile

The end effect of App and HTML5 is the same, as shown below:

For a completed template, see: %FR_HOME%\webroot\WEB-INF\reportlets\doc-EN\Parameter\Drop-down_check_box_enables_multi-value_query.cpt

Click to download the template: 

Drop-down_check_box_enables_multi-value_query.cpt