• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Workshop Formula Editor

The Formula Editor, as shown in Figure 10.5, is a common tool used across all the different types of formulas accessible through the Formula Workshop. The Formula Editor is composed of five distinct areas:

  • The Fields area (top left frame of the Formula Editor) includes all the available report, formula, summarization, and database fields that can be added to the current formula.

  • The Functions area (top center frame of the Formula Editor) includes the pre-built Crystal Reports functions and Custom functions that are available to be added to the currently edited formula.

  • The Operators area (top right frame of the Formula Editor) includes a number of operators that can be used in the currently edited formula. Examples of operators include +, *, IF/THEN/ELSE, CASE, AND/OR, and so on.

  • The Editing area (large bottom frame of the Formula Editor) is the free-form text editing area where formulas are formed through either direct typing or double-clicking selections from the other three Formula Editor frames.

  • The toolbar area contains a number of Formula Editor options including toggles on the different frames, some book-marking options, an important formula syntax checking button (x+2), and the Crystal versus Basic Syntax drop-down box.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint