HP Intelligent Management Center Standard Software Platform - Manual (Page 478)

Note:
For more information on query filter operators and values, see Query
filters and prompts .
5. Click Add a subquery to add an additional subquery to the query filter.
By default the two subqueries are linked in an AND relationship. Click the
AND operator to toggle between AND and OR.
In addition to linking subqueries in AND or OR relationships, you can nest
them (create subqueries within subqueries) by dragging an existing
subquery to the white area of the subquery outline. In this case the inner
subquery becomes part of the WHERE condition of the outer subquery.
Subquery parameters
A subquery or set of subqueries contains the following parameters:
Description Parameter
The object whose values are used to
filter the result objects.
You can include more than one Filter
Object. If you do, Crystal Reports
concatenates the values of the ob-
jects you specify.
Filter Object(s)
The object that determines which
Filter Object values the subquery re-
turns.
You can include more than one Filter
By object. If you do, Crystal Reports
concatenates the values of the ob-
jects you specify.
Filter By Object(s)
478 Crystal Reports 2008 SP3 User's Guide
Building Queries 18
Filtering data using subqueries and database ranking