### BeforeReadingRecords

Basic and Crystal syntax.

##### Returns

None

##### Action

Specifies that the formula is to be evaluated before the database records are read.

##### Typical uses

Formulas are normally evaluated at the following times:

- If no database or group field is included in the formula, the formula is evaluated before the program reads database records.
- If a database is included in the formula, the formula is evaluated while the program reads database records.
- If a group field, page number field, subtotal, etc., is included in the formula, the formula is evaluated after database records are read and while the data from the records is being printed in the report.

BeforeReadingRecords forces the formula to be evaluated before the program reads database records. When this function is used in a formula, the Formula Checker returns an error message if you attempt to include elements in the formula (database fields, groups, etc.) that must be evaluated at a later time (while reading or while printing records).

##### Examples

The following example is applicable to Crystal syntax:

BeforeReadingRecords;
ToNumber ("12345")

Forces the formula (which contains no database fields or groups), to be evaluated before reading records.

Note: If you try to include a database field or group in this formula, you will get an error message.

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