Supress - what is wrong with my formula 1

[BCarol]

This is what I want:

(CurrentFieldValue = 0 and {testH.UHEAD3_13} ="") or ({test1.ctotid} IN ['O','C'] and {test1.REP} IN ['No','Nc','NC'])

However, it suppresses everything.

if I use the first part, i.e.:

(CurrentFieldValue = 0 and {testH.UHEAD3_13} ="")

it works OK.
How do I enter my formula so that Crystal reports is happy?

(I am using CR9).

 

[Madawc]

You've probably hit a null - formulas fail if a null is encountered.

To check, separate each test out in its own formula field, e.g.

{test1.ctotid} IN ['O','C']

Put each of these besides the data and check that it shows 'True' or 'False'. If it shows as blank you have hit a null and should do an IsNull test before checking for other values.

Once you have the tests working correclty, you can use them anywhere by just entering the name, e.g.

Boolian1 or (Boolian2 and Boolian3)

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods sometimes change between versions, and higher versions have extra options. In this case, it probably makes no difference.

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

 

[BCarol]

Thanks for the information that a formula fails if a null is encountered.

Most helpful.