Excluding data
You use comparison operators, such as Equal to, Greater Than, or Less Than, to evaluate the filter condition to determine which data to include. Sometimes it is more efficient to specify a condition that excludes a small set of data. For example, you need sales data for all countries except the USA. Instead of selecting all the available countries and listing them in the filter condition, simply use the Not Equal to operator. Similarly, use Not Between to exclude data in a specific range, and Not Like to exclude data that matches a string pattern.
For example, the following filter condition excludes orders with amounts between 1000 and 5000:
OrderAmount Not Between 1000 and 5000
The filter condition in the next example excludes products with codes that start with MS:
ProductCode Not Like 'MS%'

Additional Links:

Copyright Actuate Corporation 2013 BIRT iHub 2