Articles in this section
Category / Section

How to get distinct values in parameter dropdown


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.

  1. Create a new parameter or edit an existing parameter.
  2. In parameters configuration panel, enable the Show unique values checkbox. 
  3. Save the parameter.

When the report runs, the unique values will be listed in parameter dropdown

Was this article useful?
Help us improve this page
Please provide feedback or comments
Comments (0)
Please  to leave a comment
Access denied
Access denied