You can do this a couple of ways. The easiest is going to be to use a running total.
1. Create a new running total in the Field Explorer
2. Type of Summary is Count. Field to summarize can be any field in the table - for this type of count, I usually use a unique identifier like an Identity (MS-SQL) or Sequence (Oracle) field.
3. Evaluate - Use Formula. Click on the Formula button and enter:
{ServiceEntity.LaborRate} > = 0 and {ServiceEntity.LaborRate} < 30
4. Reset on Change of Group - select your Group 2.
Put this running total in your Group 2 footer to display your count.
-Dell
IP Logged
