Question Re: How to restart numbering at each group in Technology Q&A

How to restart numbering at each group

Former Member — Fri, 02 Sep 2016 17:14:39 GMT

I have a report that contains many groups.

Each record is currently numbered using this formula Totext(RecordNumber,'#') & '.'

How do I get the numbering to restart back to 1. at each new group?

Re: How to restart numbering at each group

juancarlos_huerta — Fri, 02 Sep 2016 17:34:25 GMT

Hi, Ron.

Review this URL:

how to reset the record no in the crystal report when the group header change ?

reset variable for each group (crystal reports) - Stack Overflow

Regards,

JC.

Re: How to restart numbering at each group

vitaly_izmaylov — Fri, 02 Sep 2016 17:34:59 GMT

I would suggest to use Manual Running Total. See a sample document at:

Crystal Report - Manual Running Total Formulas

Re: How to restart numbering at each group

Former Member — Fri, 02 Sep 2016 20:26:14 GMT

Thanks for the reply. Unfortunately I'm not exactly sure how to do that. Is there a step-by-step tutorial somewhere?

Re: How to restart numbering at each group

vitaly_izmaylov — Fri, 02 Sep 2016 23:21:26 GMT

Ron,

From the sample report I mentioned, copy the Count-Reset formula and place it to your Group Header. Then Copy the Count-Evaluate formula and place to Details section.

Re: How to restart numbering at each group

ido_millet — Sat, 03 Sep 2016 11:01:34 GMT

Insert a Running Total that COUNTs a column that is never NULL and resets at that group level.

Re: How to restart numbering at each group

Former Member — Tue, 06 Sep 2016 18:25:52 GMT

Thanks Vitaly,

How do I format the number to be like

instead of

1.00

2.00

3.00

Re: How to restart numbering at each group

vitaly_izmaylov — Tue, 06 Sep 2016 19:37:31 GMT

the Count-Evaluate formula should be modified like:

WhilePrintingRecords;

numbervar f;

f:=f+1;

ToText ( f, "#") & " . "