Download User's Guide

Transcript
Once bookmarks are placed on a formula, you can quickly jump between
bookmarks by using buttons on the Formula Editor toolbar. Click the
Next Bookmark and Previous Bookmark buttons to jump to the next and
previous bookmark, respectively. When you click these buttons, the
insertion point moves to the beginning of the line marked by the next or
previous bookmark.
You can easily delete bookmarks that you don’t need. Simply position the
insertion point in the line of text which is marked with a bookmark and
click the Toggle Bookmark button. The blue dot disappears from the gray
column left of the text line, indicating that the line is not bookmarked. To
remove all bookmarks from your formula, click the Clear All Bookmarks
button on the Formula Editor toolbar.
Fields tree
The Fields tree contains all the fields you can use as formula arguments.
Fields already used in the report.
Formulas used/defined in the report.
Parameter fields used/defined in the
report.
All active database fields.
NOTE: The Fields tree is resizable. It is also dockable; you can right-click
within the tree to toggle the dockable property on/off. You can also rightclick and choose Hide from the shortcut menu to hide the tree box.
HOW TO INSERT FIELDS INTO A FORMULA
Fields can be inserted into a formula in two ways:
1. by placing the I-beam cursor where you want the field to appear in
the Formula text box of the Formula Editor, setting the insertion point
and then double-clicking the desired field in the Fields tree, or
2. by placing the I-beam cursor where you want the field to appear in
the Formula text box and then typing it in manually.
NOTE: Be sure to review the correct syntax for using fields in your
formulas. If you fail to include the file name, include the separating
period, or surround the field in braces, the program will generate a
Formula Compiler Error message detailing your error. See Formula syntax,
Page 306, and search for Error Messages and Formula Compiler Warnings in
Seagate Crystal Reports online Help.
Introduction to Formulas
301