This section explains how to get distinct values and display in a SSRS parameter dropdown when data set query returns duplicates.
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.
Show unique valuescheckbox.
3. Save the parameter.
When the report runs, the unique values will be listed in parameter dropdown.
The ability to get distinct values from parameter drop down feature was introduced in the BoldReports version 5.2.26. Ensure you have upgraded your report server to this version or later to access this feature.