A stand-alone filter is a filter created as an independent object. Once a stand-alone filter has been created, you can add it to a report. To compare stand-alone and embedded filters for reports, see About filters.
To add a stand-alone filter to a report:
Open the report for which you are creating a filter. From the Home menu, select Design.
If the Report Filter panel is
not displayed above the report, display it by clicking the Filter
icon on the toolbar.
From the left, select All Objects and navigate to the filter you want to add to the report.
Right-click the filter and select
Add to Report.
Note: If you added a prompted filter, the filter name
is displayed when you first add the filter to the report. Once the
report has been executed, and you return to edit the report, the filter's
definition is displayed rather than the filter name.
If other filter qualifications have been added to the report, determine the order that the qualifications are evaluated by clicking the Shift up icon next to a filter qualification.
To run the report, click the Run Report icon .
Save the report.
Asking for user input into a filter's definition
Filtering data based on attribute forms: Attribute form qualification
Filtering data based on attribute elements: Attribute element list qualification
Filtering data based on metric values or rank: Set qualification
Filtering data based on report results: Shortcut-to-a-report qualification
Filtering data based on an existing filter: Shortcut-to-a-filter qualification
Creating a filter within a report: Embedded filters
_____________________________
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
Legal Notices