|
|
|
| Filters | Filters allow you to select only a subset of records in your HTML reports. You create a filter by entering a filter expression into the multi-line edit box. The easiest way to do it is by selecting parts of your filter expression from the popup menu (right-click). In addition to a filter expression you can select two options: Case Sensitive, and Partial Compare. Case Sensitive option means that the filter expression will be evaluated in a case-sensitive mode (the text must match exactly). Partial Compare allows you to use a * character as a wildcard. For example, A* will match all words beginning with a letter A. |
| Filters |
Typically, a filter expression consists of one or several sub-expressions joined by logical operators (AND, OR, NOT). A filter sub-expression usually consists of a data field
name, a comparison operator, and a constant (constants must be surrounded by a single quote character).
|
| Some filter examples |
- this filter expression will select only records in which the LAST_NAME field begins with letters K-X: (LAST_NAME >= 'K') AND (LAST_NAME <= 'X') - this filter expression will select only records in which the ENTRY_DATE field is greater than 10/01/97: ENTRY_DATE > '10/01/97' |
