FORMATTING

[emuye]

I have a field name called fax number in my Report. On some ocassions it does bring a blank record form the database when there are no fax numbers supplied by the customers and sometimes for example 259-559-5547 "? " a question mark attached at the end . I would like to format this field in this way:whenever there is no record from the database i would like to display on my report "no fax number" and also i would like to get rid of the "?" question mark from my report.
thanx

 

[bdreed35]

Create a formula with the following code:

If isnull({table.fax}) or {table.fax}="" then
    "No Fax Number"
Else
    left({table.fax},12)

Use the formula instead of the fax field on your report.

~Brian

 

[emuye]

Thank you it worked!One more thing that i forgot to mention previously is it possible to convert fax number 000/000/0000 to no fax number.

 

[synapsevampire]

Sure:

If isnull({table.fax})
or
{table.fax}=""
or
{table.fax}="000/000/0000"
then
"No Fax Number"
Else
left({table.fax},12)

-k