User`s guide

8.2.5.1 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.
8.2.5.1.1 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.
The Select Expert dialog box appears.
Note:
If you click the Select Expert button without first highlighting a summary field in your report, the
Choose Field dialog box appears.
2.
Use the drop-down list to enter your selection criteria for the indicated field.
2012-03-14153
Sorting, Grouping, and Totaling