Counting Specific Rows

[ccshadow]

I'm new to Reporting Services so this may be a painfully simple question to answer. The report I'm creating needs to count rows that reach certain criteria. For example, counting the number of rows where the days worked is greater than 5. Seems like the following should work, but it doesn't.

=Count(Fields!daysWorked.Value > 5)

How do I accomplish this?

 

[xlbo]

try

=SUM(IIF(Fields!daysWorked.Value > 5,1,0))

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question