Formula Workshop Dialog Box
The Formula Workshop is the place in Crystal Reports where you can work with all types of formulas, custom functions, and SQL Expressions. The workshop consists of a toolbar, a tree that lists the types of formulas you can create or modify, and an area for defining the formula itself.
To access this dialog box, right-click in the Report Designer, point to Report and click Formula Workshop.
| Toolbar | See Formula Editor Dialog Box for a description of each of the buttons on the various Formula Workshop toolbars. |
| Tree view | The Workshop Tree contains folders for each type of formula you can create in Crystal Reports. It also contains folders for custom functions and SQL Expressions. If the workshop appears as the result of using a specific command (for example, you've selected the Record command on the Selection Formulas submenu), the appropriate folder in the tree is selected, and the appropriate version of the Formula Editor appears.
Expand any folder in the tree to see the formulas that already exist. New formulas can be added, and existing formulas can be edited or deleted as needed. Note The Workshop Tree can be docked. By default, it appears docked on the left-hand side of the Formula Workshop, but you can manually dock it on the right-hand side. In free-floating mode, the Workshop Tree can be dragged to any location in the workshop. |
| Definition area | The definition area of the Formula Workshop is where you define or modify your formula, custom function, or SQL Expression. A version of the Formula Editor dialog box is the primary editor you will encounter in the definition area, but you might also see the Formula Expert or one of a number of dialog boxes used for working with custom functions. |