The Filter button in the Filter page of the Reports Explorer and the report wizards allows you to determine which records to include in the report. The Exclude button allows you to specify which records to exclude from the report. We call this a "negative" query because it looks for the absence of data, such as all customers you didn't contact in 2007 or all customers who didn't buy Widgets.
You may think that the way to do this is filter on Contact Date is not between 01/01/2007 and 12/31/2007 or Product Name is not equal to Widgets. However, this will not give the results you expect for two reasons:
The solution is to use an exclude filter. This tells Stonefield Query to exclude those records matching the exclude conditions. For example, creating an exclude filter on Contact Date is between 01/01/2007 and 12/31/2007 means you want to exclude customers who have an activity record in 2007, which therefore gives you those customers who did not have an activity record in 2007. To get customers who didn't buy Widgets, use an exclude filter of Product Name equals Widget. This excludes those customers who bought Widgets, so it gives you everyone who didn't buy Widgets.
The way an exclude filter works is that it first takes all records, then it removes those matching the exclude conditions, leaving the rest, which obviously don't match the conditions.
Creating an exclude condition is just like creating a normal filter condition. The Exclude and Exclude Condition dialogs work exactly the same as the Filter and Filter Condition dialogs. The only difference is that the conditions you specify for an exclude filter are used to exclude records from the query rather than include as a filter would normally do.