Skip to Content
avatar image
Former Member

Filter out datasets with empty field

Hi Experts,

I want to filter a Table: Filter out all datasets where the FieldXY is empty. I tried with the filteroperator with expressions like '... is equal to NOT NULL' or '... is equal to NOT ''', but without result! Can some one give me the right expression?

Kind regards, Bernd

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Mar 31, 2008 at 01:40 PM

    Hi Bernd,

    Have you tried defining the following expression in the Field column of the Define Filter dialog?

    =!ISNULL(@FieldXY)

    Best regards,

    Udi

    Add comment
    10|10000 characters needed characters exceeded