How to exclude rows from your Report

To exclude rows from your report, you can input a filter formula in the Report section of the designer:

This normally specifies which rows to include, but you can also use the "is not" or "different than" symbol which is "<>" to specify which to exclude.

So as in the example above we can construct a formula saying:SQL

[Customer Email] <> "" AND [Customer City] <> ANY("London", "Brisbane", "Sydney") AND [Customer Country] <> NULL

Which would translate to "only include rows which do NOT have an email of and which do NOT have their city as London, or Brisbane or Sydney and which do NOT have an empty Country.

All the formula functions available are listed at