Operation Manual

Using Formulas
Creating and modifying formulas
22
428 Crystal Reports User’s Guide
7. Click Save to save the formula to the Formula Fields folder of the
Formula Workshop.
You can now use this formula in your report just as you would use a formula
you created in the Formula Editor.
Editing formulas
1. On the View menu, click Field Explorer.
The Field Explorer dialog box appears.
2. Right-click the formula you want to edit and choose Edit.
The Formula Workshop appears with the Formula Editor active.
3. In the Formula Editor, edit the formula.
4. Click Check to identify any errors in the formula.
5. Fix any syntax errors the Formula Checker identifies.
6. When the formula has the correct syntax, click Save and close on the
Formula Workshop toolbar.
Searching and replacing text
1. On the View menu, click Field Explorer.
The Field Explorer dialog box appears.
2. Right-click the formula you want to edit and choose Edit.
The Formula Workshop appears with the Formula Editor active.
3. On the Expressions Editor Toolbar, click Find or Replace to open a Find
dialog box.
From this dialog box, you can search and replace text within the Formula
text box.
Tip: Be sure to select the area you want to search from the Search list.
4. Click the Mark All button to mark all occurrences of the search text.
5. Click the Replace All button to replace all occurrences of the search text
with the contents of the Replace with text box.
You can also search (but not replace) within any of the Formula Editor trees
(use the Search options to specify which list boxes you are searching). The
Mark All, Replace, and Replace All buttons become inactive when you specify
a search within a list box.