WebFOCUS Online Help > Managed Reporting End User > Creating a Report With Report Assistant > Limiting Data With Filters
In this section: |
Filters enable you to quickly select predefined criteria that limit data included in a report. Filters are selection criteria (Where statements) that an Administrator creates for you to apply as needed, without having to create your own selection criteria.
WebFOCUS displays filters in filter groups. Each filter group can contain multiple filters. Selecting a single filter within one group creates a report with simple filtering criteria. By selecting multiple filters within a group or combining filters from different groups, you can create complex filtering expressions.
Note: Filters are only available when you are creating a report using a Reporting Object as a template. If you do not see filters, this means they have not been developed for this Reporting Object. Filters are not available when building a Standard Report or a Custom Report.
The following image shows a few sample filters as they appear in the Selection criteria tab of the HTML Report Assistant. They are listed by Group and Name.
Simple filtering criteria consists of one or more filters from the same filter group. If you select only one filter, the data must match that filter to be included in the report. If you select multiple filters from the same filter group, the data must match only one filter to be included in the report. This type of criteria is an OR criterion.
Complex filtering criteria consists of one or more filters from multiple filter groups. Data must match one filter from each filter group to be included in the report. This type of criteria is an AND criterion.
Alphanumeric fields include the following operators:
These operators generate the appropriate LIKE and NOT LIKE expressions using the character mask available in the expressions list when creating a WHERE statement.
| WebFOCUS |