InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 09:11:19 GMT20http://www.sqlservercentral.com/Forums/Topic1425150-150-1.aspxHi, 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 :-)CherrsFri, 01 Mar 2013 04:21:21 GMTGazarethhttp://www.sqlservercentral.com/Forums/Topic1425150-150-1.aspx[quote][b]Gazareth (3/1/2013)[/b][hr]Hi, how is it not working - error, wrong count, something else?CheersGaz[/quote]Thank you for your reply!I now changed the expression to =CountDistinct(Fields!columnname.Value) but I get the following results:Year Count %Var2000 1 12001 1 1 1 12002 1 1 1 1 1 1But I need the total per year to be added together.Thank you!Fri, 01 Mar 2013 04:09:13 GMTtt-615680http://www.sqlservercentral.com/Forums/Topic1425150-150-1.aspxHi, how is it not working - error, wrong count, something else?CheersGazFri, 01 Mar 2013 03:38:53 GMTGazarethhttp://www.sqlservercentral.com/Forums/Topic1425150-150-1.aspxDear 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!Thu, 28 Feb 2013 09:56:38 GMTtt-615680