CR11-Reset Recordnumber at change in group 2

[Anushkas]

Hi there,

I am using CR 11.

I figured out how to use recordnumber in a report. I am not able to figure out how to reset the recordnumber at change of a group.

For ex: If i have 200 records in report, the numbering is from 1 - 200 across all 4 regions. my first region could break at 20 or 55.. i would like to see 1-55 for the first area and then reset for the next area and if there are 10 records in the next area it shd show 1 to 10 as recordnumber.
Can you please guide me in the direction of how to reset the recordnumber when group change occurs. I would like to reset the recordnumber back to 1.

For example : I have 4 regions. I want the report to show me the recordnumber for each group. I have the ttl for each group. I would like to see the recordnumber based on the report. How can I do this. This way I can see who is next in the list in each area for treatment. Any help provided would be helpful. thanks a lot.

Thanks Usha

 

[MrBillSC]

RecordNumber is a Crystal Reports special field that can not be reset. You can create a formula to create your own record numbers as follows:
// formula @CntRegion - Place in detail section.
WhilePrintingRecords;
NumberVar CntRegion;
CntRegion:= CntRegion + 1

// formula @CntRegionReset - Place in group footer and suppress.
WhilePrintingRecords;
NumberVar CntRegion:= 0

MrBill

 

[lbass]

Or you could insert a running total instead of doing a manual one, where you count a recurring record, evaluate for each record, and reset on change of group.

-LB