Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Location
    Toronto
    Posts
    1

    Question Unanswered: Formating Numbers in Standard Reprts

    Hi Everyone,

    I am looking for some help formating numbers with Crystal Reports. I am trying to format phone and fax numbers...currently they are showing up as:

    1234567890

    I would like to be generating reports which came out:

    (123) 456-7890

    Any suggestions?

    Thanks!

  2. #2
    Join Date
    Apr 2004
    Posts
    21
    If your data is a string then the following formula will work:

    PICTURE({YourString}, '(xxx) xxx-xxxx')

    If you data is numeric then the following formula will work in Basic Syntax:

    dim holdphone as string

    holdphone = cstr({YourNumericField}, "0000000000")
    formula = picture((holdphone), "(xxx) xxx-xxxx")

    Hope this helps!!

Posting Permissions

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