Supressing Formula.

[HighlandJinx]

I'm having problems with the ISNULL statment in my current report. I'm creating a missing data report so that it only data MISSING from a table is shown. there are several fields in the table that we check for either a NULL value(no data) or "-" or "N/D".

The problem is this:

The detail section has a formula that SUPRESS the section that DOESNOT have missing or the stated values. i use. ISNULL({FIELD}) <> TRUE or
{FIELD} <> &quot;-&quot; or
{FIELD} <> &quot;N/D&quot;

When i test this the report is blank, i know there are missing data fields as i'm using a test database riddled with missing fields... can anyone help me?

 

[Naith]

If you're only interested in empty fields, why don't you use that criteria in the selection expert? Then you wouldn't have to worry about conditional suppressions.

But, on the point of conditional suppression, I wouldn't use that OR operator to base the suppression. Try

not ({field} in ['','-','N/D'])

instead.

Naith

 

[HighlandJinx]

Naith,
I tried the formula you gave in my supressing field and it almost works, it soesn't display any NULL/BLANK fields. i tried using the same formula in the SELECTION expert and it did exactly the same, i tried with both single and double quotation marks and with a SPACE between the marks and no SPACE between the marks, yet it still doesn't show NULL fields. I affraid i'm stumped on this one. is there any more advice you can give me?

 

[Naith]

Well, to be fair, my formula doesn't check for nulls - it checks for '', which is different. I was being a smartass and assuming that when you didn't get anything when you said you searched for your field being null, it's because your database considered the fields to = ''.

Anyway, check for both, just to keep your bases covered. If you can do it in your Selection Criteria, do it there; but the formula I'll give you will work in the select expert, or as a conditional suppress.

({field} in [&quot;&quot;, &quot;-&quot;, &quot;N/D&quot;] or
isnull({field}))

Reverse the logic if you have to use it as a conditional suppressant.

Naith