Count Function In Reporting Services

• tt-615680

  SSCertifiable

  Points: 7835

  More actions

  February 28, 2013 at 9:56 am

  #394281

  Dear All,

  I'm trying to do a simple query where I want to count a Column with a Dataset but its not working for some reason. I'm using the following query:

  Count(Fields!columnname.Value, "Dataset1")

  Thank you in advance!

• Gazareth

  One Orange Chip

  Points: 27737

  More actions

  March 1, 2013 at 3:38 am

  #1592297

  Hi, how is it not working - error, wrong count, something else?

  Cheers

  Gaz

• tt-615680

  SSCertifiable

  Points: 7835

  More actions

  March 1, 2013 at 4:09 am

  #1592304

  Gazareth (3/1/2013)

  ---

  Hi, how is it not working - error, wrong count, something else?

  Cheers

  Gaz

  Thank you for your reply!

  I now changed the expression to =CountDistinct(Fields!columnname.Value) but I get the following results:

  Year Count %Var

  2000 1

  1

  2001 1

  1

  1

  1

  2002 1

  1

  1

  1

  1

  1

  But I need the total per year to be added together.

  Thank you!

• Gazareth

  One Orange Chip

  Points: 27737

  More actions

  March 1, 2013 at 4:21 am

  #1592308

  Hi, yeah CountDistinct will do that, if every value in the column is the same, which it looks like it is (year?).

  One solution would be to change the column in your expression to one that's unique in every row, and that you can guarantee it always will (else future counts could be wrong), or go back to using just Count - still not sure what was wrong with that first time around 🙂

  Cherrs