Fill in field with leading 0's 3

[riverame]

I am trying to bring in some fields that need to be a fixed length. For example, I have invoice number 2598 and it needs to be 15 chars long with leading 0's in my report. I have tried several formulas and I either get all 0's or nothing. Can anyone help me, Please? Thank you in advance.

 

[mbarron]

Create the following formula (replace {order.number}with the field you want to convert to 15 characters):

If order number field is a number:
ReplicateString ("0", 15-length(totext({order.number},0,"&quot)) & totext({order.number},0,"&quot

If order number field is a string:
ReplicateString ("0", 15-length({order.number})) & {order.number} Mike

 

[riverame]

thanks, I just figured that out, but I am new to this forum and it looks like my response got posted to the next thread. Thanks for the info. I appreciate it.

 

[chelseatech]

I'd use
ToText({table.field},"000000000000000&quot
Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[dgillz]

Bruce-

Are you saying the argument in the totext() function works like the picture() function? This is all news (and good news) to me. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[kenhamady]

Yes, that is it exactly. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com