Record Number Function Question 1

[jehanzebn]

Morning all,

I am aware that the record number function is used to allow "auto numbering" function in your report. However can you customize the numbering system so that it can start with 6 digits, i.e. 000001, 000002, 000003 and so on....

I have tried to use the "Number" tab under the field properties but it did not work.

Any ideas?

Regards

Jehanzeb
Crystal Reports 2008
Visual Studio 2008
Informix Database

 

[jehanzebn]

Got it!

right(('00000'+Totext(recordnumber,0)),6)

Regards

Jehanzeb

Jehanzeb
Crystal Reports 2008
Visual Studio 2008
Informix Database

 

[lbass]

Or you could have used:

totext(recordnumber,"000000")

-LB