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.
I figured it out all by myself. ::-)
I will continue to use this forum though, I think it is great.
replicatestring("0", 15-length({RptInv2.InvNbr}))+{RptInv2.InvNbr}
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.