Suppress field help

[TechUser23]

My current formula:

if isnull({SB1001_main.PatientPhone1}) then "" else
if isnull({SB1001_main.PatientPhone1}) then
{SB1001_main.PatientPhone1} else
{SB1001_main.PatientPhone1}+" / "+{SB1001_main.PatientPhone1Type}

My issue is if there is no phone # entered, its reporting the following:
() - /

Can I have it just be blank and not report any of these characters??

 

[lbass]

Please correct your post. The formula's first two lines are the same, and nowhere does it show the characters "()-". If these are in the field itself, then show some samples of the field, also.

-LB

 

[TechUser23]

Perhaps its in the sql statement then ....

I just checked that, and sure enough it was the sql. Now all I'm getting is the '/' if null. Can I suppress that too if null?

 

[lbass]

Yes, but the solution awaits your correcting your post.

-LB

 

[Madawc]

Try

if isnull({SB1001_main.PatientPhone1}) 
then "" 
else
[b]if isnull({SB1001_main.PatientPhone1Type})[/b]
then {SB1001_main.PatientPhone1} 
else {SB1001_main.PatientPhone1} + " / " +{SB1001_main.PatientPhone1Type}

You were doing the same test twice, rather than testing the second field.

You should maybe also be testing for spaces and "()".

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10