Tip:
Creating a formula field is similar to creating a formula in Microsoft Excel®.
Previous Topic: Editing Crystal Reports
Use the different branches of the tree on the left side of the designer view to access the different types of fields in your report. From here, you can editing, renaming, or deleting formulas, creating new formulas, or inserting formula fields into your report.
Database Fields. A database is a receptacle designed to store related data. Each database record is made up of one or more database fields. Each database field can hold one piece of data (aka value).
Formula Fields. A formula is an equation designed to produce specific data for your report. You can use formulas to perform many calculations, including the calculation of numeric values and the comparison of multiple values.
|
|
Tip: |
Parameter Fields. A parameter field will prompt the user to enter a value when used. You can use parameter fields for report titles, record selection, sorting, and a variety of other uses. Using parameter fields enables you to create a single report that you can modify quickly to fit a variety of needs.
Group Name Fields. A group is a set of records that are related to each other in some way. For example, you might group together all of your customers in the same Zone. A Group Name field is created when you insert a group into your report. The Group Name Fields list displays the Group Name fields currently in your report.
|
|
Tip: |
Running Total Fields. A running total totals all records (in the report, in the group, and so forth) up to and including the current record. For example, if your first three records have values of 2, 4, and 6, the running total for each of the three records would be 2, 6, and 12, respectively. You can use running totals to create customized summaries and totals. For more, see Running Totals.
Special Fields. General information, such as Page Numbers, Print Date, and Report Comments, are located in the Special Fields list.
Unbound Fields. Fields with no specific format. Note that ServiceCEO does NOT use unbound fields in any of its default Crystal Reports.
|
|
Caution: |
Next Topic: Adding Fields to a Crystal Report
Back to Reports Table of Contents
