Apply Existing Section Filters

Your data source administrator can create filters or prompted filters for categories in relational data sources. You can also create and save custom filters for use at a later time.

To use one or more existing filters, complete these steps:

Select either OptionsSection Filters or DataSection Filters to open the Section Filters dialog box.
In the Apply predefined filters or Apply custom filters box, select the check box for the filters that you want to apply to the section query. Select the name of a predefined filter to edit it or to view its description, which is displayed beneath the box. Select the name of a custom filter to edit it or to view its expression, which is displayed beneath the box.

Section Filters Dialog Box with Predefined Filters and a Custom Filter

If you select a prompted filter for the section query, the user sees a prompt window that must be completed before the report displays. The user can change the query results by selecting different values for the prompt. The filter creator determines the style of the prompt. For example, the prompt might appear as a drop-down list, a selection list, or a text box.

A Prompted Filter for a Section Query