User`s guide

7.1.4 Using formulas
7.1.4.1 To set up record selection using a formula
1.
On the Report menu, point to Selection Formulas and click Record.
2.
In the Record Selection Formula Editor, enter the formula by typing in the components or selecting
them from the component trees.
Note:
The resulting formula must be Boolean; that is, it must return either a True or False value.
3.
Click Check to identify any errors in the formula.
4.
Fix any syntax errors the Formula Checker identifies.
5.
When the formula has the correct syntax, click Save.
7.1.4.2 Further information about formulas
• For sample record and group selection templates, see Using formula templates.
• For complete instructions on creating formulas, see Using Formulas.
• For advanced record selection strategies and performance tips, see Using enhanced record selection
formulas .
7.1.5 Interaction of the Select Expert and the Formula Editor
The Select Expert and the Record/Group Selection Formula Editor are interactive. That is, record
selection criteria you enter via the Select Expert 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.
Because of this interactivity, you can use the two tools together as a tutorial for learning the formula
language.
2012-03-14132
Record Selection