Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Report 11 - Restart record number when new group starts

Status
Not open for further replies.

ReillyC

MIS
Feb 6, 2004
114
US
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
 
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
 
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
 
Both posts worked. I have chosen to go with Lbass's suggestions.

Thank you very your assistance
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top