Does anybody know the syntax for the Count aggregate function in reporting
services. I have a dataset that uses the query "Select Var1,Var2,Var3 From
Table1" and a textbox on the report form itself that i want to use to count
the number of times 5 occurs as a value for Var1. I have tried
=Count(Fields!Var1.Value=5) but all this does is count The number of times
Var1 occurs no matter what its value is. Does anybody know the correct way?
Thanks
:(