Show Distinct Records

• simflex-897410

  Hall of Fame

  Points: 3881

  More actions

  December 21, 2010 at 4:20 pm

  #388482

  Greetings Experts,

  I am having some serious difficulty here.

  The code below gives me the count of employees.

  =COUNTDISTINCT(Fields!empID.Value)

  That's really not what I want.

  I would like to show a list of distinct records.

  Or even a list of duplicate records whichever is easier.

  So, rather than show count in numbers, I would like to see the employees listed.

  Is this possible?

  Thanks a lot in advance

• Luke L

  SSC-Dedicated

  Points: 35547

  More actions

  December 22, 2010 at 6:32 am

  #1265469

  Seems like perhaps you might need to add an appropriate Group BY Clause to the query in your dataset.

  If that is not an option, you could also experiment with using a variety of grouping options in your data region.

  To help us help you read this[/url]For better help with performance problems please read this[/url]