Description
Forces the program to evaluate the formula while it is reading database record data.
Action
Forces the program to evaluate the formula while it is reading database record data.
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 # field, subtotal, and so on, 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.
WhileReadingRecords forces the formula to be evaluated while 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 (groups, page number fields, and so on) that must be evaluated at a later time (while printing records).This function can also be used to force a formula that includes no database fields and no group fields to process while reading records instead of before reading records.
Examples
WhileReadingRecords;
ToNumber({orders detail.QUANTITY})
Forces the formula (which contains a database field) to be evaluated at its normal time (while reading records).
If you try to include a group in this formula, you will get an error message.
WhileReadingRecords;
ToNumber ("12345")
Forces the formula (which contains no database fields or groups), to be evaluated later than it would normally be evaluated. In this case, it causes the formula to be evaluated while reading records instead of before reading records.
If you try to include a group in this formula, you will get an error message.