Choosing a formula template

To choose a formula template

1. Select the template you want to use.

   You can do this in one of two ways:

   • review the list in Record selection formula templates, and write down the formula of interest
   • find the Record Selection Formula Templates in the online help file and copy the formula of interest to the Clipboard.
2. Choose Edit Selection Formula from the Report menu.
3. Choose Record to create a record selection formula.

   The Record Selection Formula Editor appears.

   - or -

   Choose Group to create a group selection formula.

   The Group Selection Formula Editor appears.

4. In the Formula text box, type in the formula you wrote down in Step 1 or paste it from the Clipboard.
5. Replace the values (fields, text, etc.) in the formula with the values you want. For example, if the example formula is:

{file.FIELD} > 99999

and you want to limit your report to records for which the value in the {orders detail.QUANTITY} field is greater than 25, replace the existing values with the values you want, so that your selection formula reads:

{orders detail.QUANTITY} > 25

6. Click the Save and Close button when finished to exit the Selection Formula Editor.

   - or -

   Click Refresh on the Standard toolbar to preview the results.