Category / Section
How to get distinct values in parameter dropdown
Published:
Updated:
This section explains how to get distinct values and display in a SSRS parameter dropdown when data set query returns duplicates.
Steps to configure distinct values for parameters
The data set query might have duplicate records. At report run time, these values will be listed in parameter drop down as it is.
Bold Reports designer provides an option called Show unique values
when creating a parameter. User can enable this option to get distinct values in parameter dropdown.
- Create a new parameter or edit an existing parameter.
- In parameters configuration panel, enable the
Show unique values
checkbox.
- Save the parameter.
When the report runs, the unique values will be listed in parameter dropdown