formula for consecutive numbering

[RepRider]

Crystal XI with SQL

I would like to be able to insert a column that numbers the rows of detail data displayed in consecutive order.
If there are 23 lines of data then the column would show numbers 1 thru 23.

I have no idea how to do this. Can someone give me a start?

Thanks!

 

[synapsevampire]

Use a formula of:

recordnumber

Or if your sortation doesn't allow fo this, you can use a formula in the details section of:

whileprintingrecords;
numbervar MyCounter:=MyCounter+1;
MyCounter

-k

 

[RepRider]

Thanks synapse!

I will try the latter. I have tried the recordnumber but it doesn't display consecutive numbers. Mybe I did it incorrectly though.

 

[dgillz]

Rep,

Recordnumber should always work unless you have suppressed detail records. Have you done this and if so, why?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[synapsevampire]

Don: I don't think it will if they've sorted the report.

-k

 

[RepRider]

Synapse,
Theformula worked perfect!!
I will be using this A LOT!
Thank you, thank you, thank you!