In the Query section, the Filter line includes special functionality:
The Filter line is an interface for building compound filter, which are multiple filters linked together to form complex filter equations. See Setting Compound Filters.
The Filter line enables you to convert a filter to a variable filter, which prompts the user of the Interactive Reporting document file to select filters as the query is processed. See Setting Variable Filters.
When placing a filter on a request item computed with a data function, a divider is displayed on the Filter line, and the Filter icon is placed to the right of the divider. The divider indicates that the filter is applied in the SQL Having clause.
Subqueries and correlated subqueries which use the result from an inner query as the value of a filter in an outer query.