Row numbering formula not working

[Tichaona]

Hi,

I have a crystal report formula for row numbering that doesnt seem to work. Just repeats 001 on all rows.

NumberVar rowNum;
If OnFirstRecord or {Invoice Number Field} <> Previous({Invoice Number Field}) then
rowNum := 0;
rowNum := rowNum + 1;
Right('000' + toText(rowNum, 0, ''), 3)

 

[pmax9999]

Remove the line:
"rowNum := 0;"

As it is currently, you are setting the variable to 0, then adding 1 for every line, hence the result is 1 for every line.

 

[dgillz]

A variable is not needed for this, just use the special field RecordNumber.

Right("000"&ToText(RecordNumber,0,""),3)

If you don't need the leading zeros, no formula is needed at all, just drag RecordNumber on to the desired place on your report canvas.

Macola and SAP Business One Consultant
Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[Tichaona]

I have details a and details b, so want it to work for both

 

[lbass]

Your formula should being with:

Whileprintingrecords;

-LB