Crystal Report 11 - Restart record number when new group starts

[ReillyC]

I have report where I have two groups. I group by site then by employee name and then list each employees applications.

NY
Smith
app5
app10
app6
app7

NJ
Smith
app15
app9
app66
app37

I want to add the record number so that it restarts with each new group.

NY
Smith
1.app5
2.app10
3.app6
4.app7

NJ
Smith
1. app15
2. app9
3. app66
4. app37

Is this possible?

Thank You

 

[MisterMo]

create two fomulaes

1 @Counter

whileprintingrecords;
numbervar MyCounter:=MyCounter + 1

Place this one on your detail section

2 @ResetCounter

whileprintingrecords;
numbervar MyCounter:=0

place this one at the footer of the group you want to use to restart the count.

you have an option to make the second field invisible





Mo

 

[lbass]

Or you could insert a running total using the expert, where you count the field, evaluate for each record, and reset on change of group.

-LB

 

[ReillyC]

Both posts worked. I have chosen to go with Lbass's suggestions.

Thank you very your assistance