SSRS – Parameter is showing duplicate values in the drop down. – SQL Circuit

SSRS – Parameter is showing duplicate values in the drop down.

 Question:  SSRS Parameter is showing duplicate values in
the drop down.

 Answer:  We can remove duplicate records by using TSQL DISTINCT
function in report dataset. e.g. SELECT DISTINCT NAME FROM TABLE. I
t will remove the duplicate records in the
dataset as well as in the parameter
  drop
down.

Leave a Reply

Your email address will not be published. Required fields are marked *