Advertisement

02.22.2008 at 04:55PM PST, ID: 23186374
[x]
Attachment Details

Remove leading zeros in text field to show numeric values at end of string.

Asked by vsllc in Crystal Reports Software

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
[+][-]02.22.2008 at 09:59PM PST, ID: 20963825

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Crystal Reports Software
Sign Up Now!
Solution Provided By: BriCrowe
Participating Experts: 2
Solution Grade: A
 
 
[+][-]02.23.2008 at 09:54AM PST, ID: 20965824

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]02.24.2008 at 12:28PM PST, ID: 20971187

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628