Formatting a Phone Number

building reports crystal reports
1

Hello,

I need to format the phone number in this way 480-444-7212 from 4804447212.

The field in the database is Numeric.
When i go to format filed and go to Number tab i can’t see the option to do it over there.

please help me how to format the telephone number using formula may be…

Thanks
Alluri

Rajua99 :india: (BOB member since 2004-12-16)

2

can you do it on universe ?
convert it to char then add - into it ?
123-123-1234 is not a number format but a string.

Suma9898 (BOB member since 2006-08-30)

3

we are not usng Universes to create the reports.

can you tell me how to convert the number into string in crystal reports using formula…

Rajua99 :india: (BOB member since 2004-12-16)

4

Create a formula to display the phone number, something like:

Picture (ToText (TABLE.FIELD_NAME}, 0, “”), “XXX-XXX-XXXX”)

blair :canada: (BOB member since 2006-11-17)