Wednesday, June 9, 2021

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. It will remove the duplicate records in the dataset as well as in the parameter  drop down.

No comments:

Post a Comment