Formatting

[296097]

I have embedded my field(fax number) in the text box and when i run a report sometimes i get no fax number and my report instead of leaving a balank space it shows 000/000-0000 when no fax number found form the database. I would like to know if there is a way to get rid of these zeros while i have my field embeded in the text box or i should remove this particular field from the text box in order to format it.as always i appreciate your valuable help

 

[Madawc]

Create a formula field, testing for zeros and also nulls. Say

if isnull({fax}) then "No fax"
else if {fax} = 0 then "Zero fax
else totext({fax})

It helps to give your Crystal version, since newer versions have extra solutions, and some extra problems. I use Crystal 8.5

Madawc Williams (East Anglia)

 

[296097]

I am using CR 8.5 and the only thing i need here is to get rid of 000/000-0000 from my report and replace it with a balnk space.it really looks ugly and unprofessional.by the way this field is embeded in the text box.thank you for the help