Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Grouping a Formula

Status
Not open for further replies.

drinker

Technical User
May 9, 2006
57
US
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!
 
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
 
There are no nulls in the {CUSTOMER.NAME}field.
 
Sorry, seems the ({CUST_ADDRESS.NAME}) are showing, but not the {CUSTOMER.NAME}. Again ther are no Nulls in the {CUSTOMER.NAME}field.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top