Operation Manual

Using Formulas
Creating and modifying formulas
22
Crystal Reports User’s Guide 429
Copying formulas from online help
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.
u
To copy formulas from online help
1. On the Help menu, click Crystal Reports Help.
The Crystal Reports online help appears.
2. Click the Index tab.
3. Enter
formulas in the keyword field and click Display.
4. Scroll through the formula topics until you locate the formula you want to
copy.
5. Highlight the formula, right-click, and choose Copy from the menu.
Windows places a copy of the selected text on the Clipboard.
6. Return to Crystal Reports, choose View from the main menu and select
Field Explorer.
The Field Explorer dialog box appears.
7. Select Formula Fields and click the New button.
The Formula Name dialog box appears.
8. Enter the name you want to identify the formula by, and then click OK.
The Formula Workshop appears with the Formula Editor active.
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 and close on the
Formula Workshop toolbar.
Copying formulas from one report to another
You may want to copy a formula created in one report for use in another
report. Copy the text formula from one report to another via the Clipboard.