Articles in this section
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.

parameters-with-duplicate-values.a389abb.480a0c5acd567810ea4f5cbe5798537e.png

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. 
    enable-unique-value.12d3ba2.218bd17e64fe6cdac340c0ca70aaf170.png
  3. Save the parameter.

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

parameters-with-unique-values.c98a7a4.0530bf83bac4bc104c6cf91438a3d8a0.png
Was this article useful?
Like
Dislike
Help us improve this page
Please provide feedback or comments
Comments (0)
Please  to leave a comment
Access denied
Access denied