Numbering groups 1

[Terpsfan]

What I am trying to accomplish is to concatenate a number to a detail field that would indicate sort of an auto number sequence within a group. I would I guess add a 1 each time the group name changes within the group. I'm not looking to count the detail items.

Example:

REGION group header
Region#1
Region#1
Region#1

next region
Region#2
Region#2
Region#2

etc

 

[IdoMillet]

Just use a Running Total.

Alternatively, use a variable.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[synapsevampire]

What Ido means by the Running Total is to right click the field in the details and select Insert->Running Total (instructions are version dependent and may not match completely as you didn't bother to state your software version), and select a distinctcount on the group field with the reset at never. Then if you want it concatenated to another field, use something like the following in a formula:

{table.field}+totext(#RunningTotalField,0,""}

-k