Create a multi value report parameter

Multi Value Parameter is used to dynamically filter the report data based on more than one value. This section describes the steps required to create a multi value report parameter in Bold Report Designer.

Refer Create Parameter section for better understanding with the following steps.

1. Select Allow multiple values, to create a multi-value parameter.

   A multi-value parameter cannot include null values.

   

2. Click on Assign Value >> to open parameter assign dialog.

3. Select Query Value option under Available Value tab.

4. Select the dataset and fields in the drop-down list and Click OK.

5. Save the parameter.

Filter a table data based on report parameter

Using the ProductID parameter, we can filter the ProductID field values at runtime like below.

1. Select the table report item in design area.
2. Click on the Properties icon in the configuration panel, to open table properties.
3. In Table properties, click on Set Filters... button. Refer Set filters section to create new filter expression.
4. Choose the In operator and assign the ProductID parameter in the Value field. Save the filter.
5. Click on the Preview button in the report header. Select the required values in drop-down list.
6. Click on the View Report button.

Download the above report design from link.