Filters can be added to reports in two ways:
If a filter object has already been created in your project (this is a stand-alone filter) that you want to use on the report, you can add that filter to the report. To add an existing filter to a report, see Adding a stand-alone filter to a report.
You can create a filter directly in the report. However, this kind of filter cannot be used as a filter on other reports.
This topic explains how to create a filter within a report. For a comparison of both types of filters, see About filters.
Filters can be created as part of a given report, at the same time the report itself is being created. You can filter data based on any object that is part of the report’s definition. You can also use the results of another report as the filter for this report. The conditions specified by the report's filter are part of the SQL that retrieves the report result set from your database.
Open the report you want to create a filter for. From the Home menu, select Design mode.
If the Report Filter panel is not displayed above the report, click the Filter icon .
Select the object you want to base your filter on:
To base your filter on an object that is part of the report's definition, use the Report Objects pane on the left and select the object you want to base your filter on. The object can be an attribute or a metric.
To base your filter on the results of another report, select the All Objects pane on the left to navigate to and select the report you want to base your filter on.
Right-click the object and select
Add to Filter.
If DHTML is disabled, select the object and click Add.
Depending on the type of object you added to the filter, a new set of choices may appear. The links below provide steps to filter data on the object you chose:
If you are filtering based on an attribute, see one of the following:
Filtering data based on attribute forms: Attribute form qualification
Filtering data based on attribute elements: Attribute element list qualification
If you are filtering based on a metric, see Filtering data based on metric values or rank: Set qualification.
If you are filtering based on the results of another report, see Filtering data based on report results: Shortcut-to-a-report qualification.
Click the Apply icon to apply your new filter condition to the report.
You can add additional conditions to the report's filter by repeating the steps above to add another object to the filter and define the condition.
To run the report, click the Run Report icon . The report results displayed reflect the new filter.
Related topics