Copying formulas from online Help

The Seagate Crystal Reports online Help contains a section called "Formulas in Action" that covers 17 different formulas and report-related scenarios. Since the formulas you develop using the Formula Editor are text, you can copy useful online formulas directly into the Formula Editor and then modify them to fit your needs.

To copy formulas from online Help

1. On the Help menu, click Search.

   The Seagate Crystal Reports online Help appears.

2. Click the Index tab.
3. Enter "Formulas in Action" in the search field and click Display.

   The Formulas in Action Help topics appear.

4. Scroll through the topic until you locate the formula you want to copy.
5. Highlight the formula and choose Copy from the Edit menu.

   Windows places a copy of the selected text on the Clipboard.

6. Choose Insert from the main menu and select Formula Field.

   The Field Explorer dialog box appears.

7. Double click Formula Fields.

   The Formula Name dialog box appears.

8. Enter the name you want to identify the formula and click OK.

   The Formula Editor appears.

9. Place the insertion point where you want the text to appear in the Formula text box of the Formula Editor and press Ctrl-V to paste the text from the Clipboard.
10. Modify the formula by changing the fields, formulas, group fields, conditional statements, and text strings as necessary for use with the data in the new report.
11. When the formula has the correct syntax, click Save then Close.

    You return to the Field Explorer dialog box.