## Record Selection Formula Editor

This dialog box appears whenever you select the Record command from the Edit Selection Formula menu (under the Report menu).

Use the Record Selection Formula dialog box to set up a record selection formula that limits the records the program uses when preparing your report.

You can use the full range of report fields, operators, and functions to create a formula that restricts the range of data to print.

##### Interaction of the Selection Formula Editor and Select Expert

The Select Expert and the Selection Formula Editor are interactive. That is, record selection criteria you enter via the Select Expert (from the Report menu) automatically generates a record selection formula which can be reviewed and modified. Likewise, record selection formulas and modifications to existing record selection formulas automatically update the selection criteria in the Select Expert.

Note:

- You can only use Crystal syntax when creating record selection formulas.
- No field placement box appears when you create a selection formula; the formula is simply stored in the report.
- Your record selection formula must be Boolean, that is, it must result in a Yes or No answer.
- You cannot use commas in numbers you enter in a formula. Enter only the number itself.

###### Related topics

Formula Editor

Formula Editor buttons

Formula syntax

Operators

Functions

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com