beautypg.com

Selecting records, Options for selecting records, Determining which field(s) to use – HP Intelligent Management Center Standard Software Platform User Manual

Page 192: Selecting, Records

background image

Selecting records

When a field is selected to appear on a report, field values from every record
in the active table(s) are printed by default. In many cases, you may not want
to include all the values, but only a subset of those values. For example, you
may want to include:

Records only for a specific group of customers.

Records for a specific range of account numbers out of the total number
of records in the database.

Values from only those records that fall within a particular date range.

Options for selecting records

Crystal Reports includes a very sophisticated formula language that you can
use to specify virtually any type of record selection. However, you may not
always need the flexibility in record selection that the formula language
provides. The Select Expert is designed for such instances.

You can select records in one of two ways:

Using the Select Expert

Using formulas

Once you are familiar with the Select Expert and formulas, you can use your
record selection techniques to improve the performance of your reports.

For additional performance tips and advanced record selection strategies,
see

Using enhanced record selection formulas

.

Determining which field(s) to use

When you select records, you are basing your report only on those records
that meet some conditions that you have set. You base those conditions on
the kind of information you want in the finished report.

192

Crystal Reports 2008 SP3 User's Guide

Record Selection

9

Selecting records