Format Field as Phone Number on report

[Jinny]

Using Crystal 8 and AS400 Client Access ODBC.

I have phone numbers stored in my AS400 file that I want
to display as phone numbers on my Crystal Report.

Help Please

Thanks

Jinny

 

[MalcolmW]

What is the data type for the phone numbers (number or text)?
What format are they in now (if you just drop the field on the report and preview)?
What format do you want them in? Malcolm Wynden
Authorized Crystal Engineer

http://www.wynden.net

malcolm@wynden.net

 

[Jinny]

Thanks for the reply.

Now they are packed 2179352171. I want them to print
217/935-2171. There is a special format in Excel for
Phone Number. It is also possible to create your own format. Does Crystal have such a feature?

 

[IdoMillet]

Have a look at the ToText() function.

Cheers,
- Ido ixm7@psu.edu

 

[mickyd]

I used the following to convert my fieldname to a phone number format

Left (CStr(fieldname or variable),3 )&"-"&Right(CStr(fieldname or variable), 4)


fieldname or variable- name of the field from the table or variable that holds the number to format.

Left- takes the first three numbers. must be converted to a string.

Cstr - converts the number to a string.

Right- takes the last four digits of the number which also must be converted to a string.

If you need any further assistance, let me know and I'll do what I can to help. :-V