I am using Crystal XI....

I have a running total field in a subreport that sums up the number of times a 'class' is found for each user.  The running total field resets between classes.  Each user can have 1 to many classes.

 

Each user is displayed on a new page. 

Classes are sorted in alpha order. 

 

My problem is when the last class for the first user is the same as the first class for the second user.  In this case the classes are adding up together.

 

How can I prevent this?

 

Thanks for your help

I have to reset on class since each user can have more than one class and I need counts for all classes.

 

Ideally I need to reset on User+Class but I don't know how to setup the running total to reset on 2 fields.

 

Thanks for your input.