Define available values for a parameter

An available values can be specified for a report parameter to allow the user to select only valid values on report preview action. The available values defined for the parameter will be listed in the drop-down list when previewing the report.

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

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

Manual values

Follow the below steps to add available values for the parameter.

1. Select Specify option under Available Value tab.

2. Click on the Add icon. Now, a list in which you can type values and labels appears.

3. Enter the value in the Value text box, and optionally, the label in the Label text box.

   If you do not provide the label, the value is used.

   

4. Click OK and Save the parameter.

On report preview, the available values defined for the parameter will be listed in the drop-down list like below.

Query values

1. Select Query Value option under Available Value tab.
2. In Dataset drop-down, choose the name of the dataset. Datasets can be defined using the data view.
3. In Value field, choose the name of the field that provides parameter values.

   Note: These fields are retrieved from the list of column or field names in the dataset.

4. In Label field, choose the name of the field that provides the parameter names. If there is no separate field for names, choose the same field similar to Value field.
5. Click OK.
6. Save the parameter.

On report preview, the ProductID parameter will list the values of ProductID field from query data.

Remove available values

To remove the available values defined for the parameter follow the below steps:

1. Refer Edit Parameter section and open parameter properties.
2. Click on Assign Value >> to open parameter assign dialog.
3. Under the Available Values tab, choose the None option.
4. Click OK and 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 to enable grouping panel in the designer.
2. Now, click on the (Details) member field in the grouping panel to open the tablix member properties.
3. In Tablix Member properties, click on Set Filters... button.
4. Refer Set filters section to create new filter expression.
5. Choose the Equal operator and assign the ProductID parameter in the Value field. Save the filter.
6. Preview the report, now the following view will be displayed.
7. The manually created values will be listed in the drop-down. Choose any value from the drop-down list.
8. Click on View Report.