Problem with Group

[rnooraei]

I have the following formula which is attached to a group. The ELSE part is not working. It supposes to check for CONTACT_ID and if there is no CONTACT_ID, it should show "Not Assigned" but in my case it doesn't show any title for this group. any help appreciated.

if not isnull ({RPH_007_.CONTACT_ID}) then {RPH_007.NAME.B} else "Not Assigned";

 

[Madawc]

Probably {RPH_007.NAME.B} is null or spaces. Try

if isnull ({RPH_007_.CONTACT_ID}) then "Not Assigned"
else if isnull ({RPH_007.NAME.B}) 
     or {RPH_007.NAME.B} = " "
     then "No Name"
     else {RPH_007.NAME.B}

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