Grouping a Formula

[drinker]

Crystal 8.5

I have a formula in my report as follow:

if isnull ({CUST_ADDRESS.NAME})then {CUST_ADDRESS.NAME}else{CUSTOMER.NAME}

Everything works fine until I create a group of this formula and the {CUSTOMER.NAME} dosen't show, only the ({CUST_ADDRESS.NAME}). Thanks!

 

[satinsilhouette]

You need to handle the nulls in the customer name as well, perhaps in another formula and then use that formula in this one.

Thanks so much!
satinsilhouette

 

[drinker]

There are no nulls in the {CUSTOMER.NAME}field.

 

[drinker]

Sorry, seems the ({CUST_ADDRESS.NAME}) are showing, but not the {CUSTOMER.NAME}. Again ther are no Nulls in the {CUSTOMER.NAME}field.

 

[lbass]

Your formula says to show the customer address name when that same field is null. Your formula should be:

if isnull({CUST_ADDRESS.NAME})then
{CUSTOMER.NAME} else
{CUST_ADDRESS.NAME}

Also make sure you are grouping on the formula and not on one of the fields.

-LB