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] <> "john@gmail.com" 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 john@gmail.com 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 https://support.winkreports.com/portal/en/kb/articles/report-designer-formula-reference