Sunday, July 9, 2023

SSRS - How to remove the duplicate values from the report input parameter

If we are using ar eport parameter which is duplicate values. you can remove duplicate records by using T-SQL DISTINCT function in the SELECT query or stored procedure. If dataset has manual entry for available values then check the list of available values and remove the duplicate value. If Source is excel or other file system then remove the duplicacy there itself.

--TSQL statement to pull distinct records from table
SELECT DISTINCT NAME FROM TABLE


No comments:

Post a Comment