Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2008
    Posts
    3

    Unanswered: Leading Zero Suppression

    Hello, Could someone point me in the right direction to suppress leading zeros
    in a report? I'm using Crystal Reports 10. Output is from BusinessVision 7.13
    order number.
    ie report gives 000000715
    would like 000715
    Thanks

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Your question is misleading...

    You're asking how to supress leading zeroes; except your example only suppresses SOME leading zeroes.

    What are the rules here?
    George
    Home | Blog

  3. #3
    Join Date
    Jan 2008
    Posts
    3

    Clarifying

    Hi I would like to suppress "some" of the leading zeros. Is there some
    way to justify the output to just show the lowest 6 digits?
    Thanks

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Right(myField, 6)
    George
    Home | Blog

  5. #5
    Join Date
    Jan 2008
    Posts
    3
    Thanks, I'll try that and let you know.
    Regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •