Subreport Surpress formula

[muppy111]

In a Subreport I have under Section Expert/Surpress/Formula
button the formula :

({CONTACT_1.BLACK}<> "" and
{?Pm-CONTACT.BLACK} <> "")
or
({CONTACT.COUNTRY}="China" and
{CONTACT_1.UORIGIN}="C" )

Only the first part(before OR) works and also the second
part (after OR) works also, but... if I make them both with OR then only the first works.
So technically both are good, but not together. Why??

Contact_1.UORIGIN is required and _1 not a mistake,I tested this by inserting each part with // to eliminate
that part.

William.

 

[Madawc]

Try putting the two tests in formula fields, and then displaying them with the data. They should say 'True' or 'False', but I suspect some will be blank, because you've hit a null.

Nulls stop any formula unless you first test IsNull.

Once you have the formula fields working, then you can use them elsewhere by just giving the name, you don't need to say = 'true', Crystal assumes that.

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