Operation Manual

Building Queries
Query filters and prompts
18
Crystal Reports User’s Guide 359
u To select objects for an advanced filter
1. Select the object that you want to specify as a sub-set within the query
definition.
The object you select defines the aggregation context of any measures or
measure filters you place on the advanced filter later. For example, to
calculate and filter sales revenue results according to sales revenue by
service line, select the Service Line object.
2. Drag the selected dimension to the Query Filters pane.
The Filter Editor appears. By default, the name of the filter is the name of
the filtered object.
3. Check Advanced filter.
4. The next step depends on whether you want to include or exclude the
values returned by the filter from the report.
5. The final step depends on whether you want to include more objects to
further define the aggregation context of the filter.
6. You are ready to add a query filter to the objects selected in the new
advanced filter.
Retrieve this data Example Action
Retrieve the data defined in
the filter and return those
values to the report.
Retrieve data for the service
lines listed in the filter.
Do not check Exclude the
filter values from the results.
Retrieve all data except the
data defined in the filter and
return those values to the
report.
Retrieve data for all the
service lines except the
service lines listed in the filter.
Check Exclude the filter
values from the results.
What you want to do Aggregation example Action
Add more objects to the
advanced filter.
[Service Line] [Country] To add more objects, drag another
object from the left-hand pane onto
the advanced filter and select
“Advanced filter” in the Filter Editor.
Keep only one object in
the advanced filter.
[Service Line] Go to step 6.