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

• You might want to see only the groups with the highest summary values,
or the lowest.
You can select the groups that appear in the report in two different ways:
• By using the Select Expert.
• By using selection formulas.
Note:
For faster results, limit records through record selection before creating
groups. See
Selecting records .
Using the Select Expert
The Select Expert can be used to select groups of records in the same way
that you select individual records.
When you are setting up group selection criteria, instead of basing the
selection criteria on standard fields, as you do for record selection, you base
the criteria on group name fields or summary fields.
• If you have grouped your data but have not summarized it, you can only
set up group selection based on the group name field. For example, you
may want to select only those groups whose Region is Massachusetts:
GroupName ({Customer.REGION}) = "MA"
• If you have summarized your data, you can set up group selection based
on either the group name field or the summary field. For example:
Sum({Customer.LAST YEAR'S SALES}, {Customer.REGION})
> 10000
Note:
The Select Expert can be used to set up record selection and group selection
requests. When a group name or summary field is selected, the program
knows that the selection criteria you set up is intended for group selection.
In all other cases, the program knows that you are setting up record selection.
To set up group selection using the Select Expert
1.
Right-click the summary field on which you want to base group
selection and choose Select Expert from the shortcut menu.
Crystal Reports 2008 SP3 User's Guide 225
10 Sorting, Grouping, and Totaling
Grouping data