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.

1 comment:

  1. NCERT Social Question Paper Class 4
    Social Science is a subject which deals with all about our country and various areas like mountains, plains and plateaus present in our country etc… which helps students to know about their dwelling area type and environment being there etc. Every 4th class student will know about History, Civics, NCERT Social Question Paper Class 4 Geography, and Economics from the Social Studies subject.Social Science is a subject which deals with all about our country and various areas like mountains, plains and plateaus present in our country etc… which helps students to know about their dwelling area type and environment being there etc. Every 4th class student will know about History, Civics, Geography, and Economics from the Social Studies subject.

    ReplyDelete