How to get distinct values in parameter of SSRS for sharepoint list


  • I had created a report having parameter of employee name.

    but in sharepoint list i have three value of same employee name.

    So when I run the report it shows same  name of that employee 3 times in parameter.

    How can I remove this repetating values from my parameter.


    Tuesday, May 11, 2010 1:53 PM


All replies

  • Hi vyanku,

    You can use distinct query in Report parameter dataset to eliminate duplicate records. But let's say you have three employee with same name with diff. emp no, you need to make unique report parameter.. In such case, add any other column ( EmpId) with Report parameter.( Employee Name).

    This is regular case where many time dept name is added with Empname in parameter to differenciate




    Tuesday, May 11, 2010 1:59 PM
  • Hi vyanku,

    You can see the following similar thread for more information:

    If you have any more questions, please feel free to ask.

    Jin Chen

    Jin Chen - MSFT
    Thursday, May 13, 2010 8:16 AM
  • I had created another master list from whivh I get the employee list.

    Then I created another dataset in report and get the parameter values from that dataset

    • Marked as answer by vyanku Wednesday, June 02, 2010 1:29 PM
    Wednesday, June 02, 2010 1:28 PM