Problem with isnull Field 1

[Crystalfire]

Works good except when the {CUST_ADDRESS.COUNTRY} is null. Then I still need to see the {CUSTOMER.TERRITORY}. How do I insert that isnull factor into this formula? Thanks!

if {CUSTOMER.COUNTRY}<>{CUST_ADDRESS.COUNTRY}then {CUSTOMER.TERRITORY} else
if isnull ({CUST_ADDRESS.TERRITORY}) then {CUSTOMER.TERRITORY} else {CUST_ADDRESS.TERRITORY}

 

[Turkbear]

Hi,
Test for IsNull first...also be sure to have the tables linked with a Left Outer Join if the Customer may not exist in the CUST_ADDRESS table...







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Crystalfire]

The field does have null properties as the "" does not work. The tables are in a Left Outer Join.

 

[dgillz]

Use the IsNull() formula to test for nulls.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[Crystalfire]

I used the Formula if isnull ( {CUST_ADDRESS.COUNTRY})then "X". This brings back X's to the details that are blank.
What is wroung with the formula

if {CUSTOMER.COUNTRY}<>{CUST_ADDRESS.COUNTRY}then {CUSTOMER.COUNTRY}
else
if isnull ({CUST_ADDRESS.COUNTRY}) then {CUSTOMER.COUNTRY} else {CUST_ADDRESS.COUNTRY}

 

[Turkbear]

Hi
Test for IsNull first:

if (isnull ({CUST_ADDRESS.COUNTRY})or {CUSTOMER.COUNTRY}<>{CUST_ADDRESS.COUNTRY}
then 
{CUSTOMER.COUNTRY}
Else
{CUST_ADDRESS.COUNTRY}

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Crystalfire]

Thanks Turkbear. Worked Great.

 

[Turkbear]

Hi,
No problem - Crystal's handling of Nulls in formulas rivals Oracle's handling of them..Very 'special needs'..






To Paraphrase:"The Help you get is proportional to the Help you give.."