Print Page | Close Window

Incremental Record Number

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=6319
Printed Date: 19 May 2024 at 6:56am


Topic: Incremental Record Number
Posted By: debmac
Subject: Incremental Record Number
Date Posted: 11 May 2009 at 5:39pm
I need to add an incremental record number to a report, so each line would look like:
1 abc
2 def
3 ghi

I have tried the Record Number field, but the record numbers dont start at 1 and are not consecutive.

Anyone has a formula or similar I could use?

many thanks


Replies:
Posted By: angelyin1984
Date Posted: 11 May 2009 at 11:19pm
or try to use group number(field explorer -> special field -> group number)

Posted By: lockwelle
Date Posted: 12 May 2009 at 6:26am
shared variables.  whereever you need the numbering to start, set it to 0 in the group above.  In the section you want the number a formula like:
 
shared numberVar lineNo := lineNo +1
 
HTH

Posted By: debmac
Date Posted: 12 May 2009 at 4:15pm
the formula worked. thanks heaps!


Print Page | Close Window