I'm using Crystal Reports 10 and I'd like to remove the leading zeros in a report field. The field is 10 characters and contains the invoice number. The invoice number is the right x number of characters with leading zeros filling in the remaining spaces to the left up to 10. How can I extract just the invoice # regardless of how many characters it is (currently, some are 4 and some are 5)?
I have very little experience with the program so please be as detailed as possible with all explanations.
Thanks.
Start Free Trial