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

The Select Expert can also be used to set up some sophisticated requests:
• Customers whose names start with "A", "M", or "S."
• Customers from California or Florida who ordered in July.
These are all range limit requests. One or more constants define the range.
The program compares the field value in each record to the constant(s) and
rejects records with values outside the range. The report is limited to values
within the range. You can set up all of these types of record selection requests
without any previous knowledge of the formula language.
Note:
The Select Expert can be used to set up both record selection and group
selection requests. When a group name or summary field is selected, the
program knows that the selection criteria set up is intended for group
selection. In all other cases, the program knows that you are setting up record
selection.
To set up record selection using the Select Expert
1.
On the Expert Tools toolbar, click Select Expert.
The Select Expert dialog box appears.
Note:
If you click the Select Expert button without first highlighting a field in your
report, the Choose Field dialog box appears. Highlight the field on which
you want to base record selection and click OK. The Select Expert
appears.
2. Use the drop-down lists to enter your selection criteria for the indicated
field.
3. Click OK when finished.
194 Crystal Reports 2008 SP3 User's Guide
Record Selection 9
Selecting records