Crystal reports and Phone #'s

[Steve]

I can't seem to find any information on displaying a phone number in

crystal reports in the (###) ### - #### format instead of 1234567891

when making a report. Can anyone point this out to me?

[garmar]

In crystal reports, create a formula and try the picture function found under "Additional functions"

Example: Picture ({customer.phone},"(xxx) xxx-xxxx" )

If the string is 1234567891, then the outcome will be (123) 456-7891. This will work.

OR

you can use the Mid function.

Example: "(" + Mid ({Customer.phone},1 ,3 ) + ") " + Mid ({Customer.phone},4 ,3 ) + "-" + Mid ({Customer.phone},7 ,4 )

If the string is 1234567891, then the outcome will be (123) 456-7891. This will also work.

GaryCaspelich