Key points for editing a copy of a formula, Deleting formulas – HP Intelligent Management Center Standard Software Platform User Manual

Page 578

Advertising
background image

Key points for editing a copy of a formula

When making changes, use the following points as a guide:

All fields, formulas, and group fields referenced in the formula copy must
actually exist in the new report. This means that any database referenced
in the original formula (or a database with the same structure, field names,
and alias) must be active in the new report.

If such a database is not active, you must change the field, formula, and
group field references in the formula copy to correspond to elements in
your new report.

If the formula contains conditional elements, make certain that the
conditions apply to the data in the new report. For example, if the formula
in your old report performed an action when the quantity was greater than
100, make sure that the greater than 100 condition makes sense in the
new formula. When modifying a formula, you may find that greater than
10 or greater than 2000 makes more sense with your new data.

If you are using the formula with new data, and if your report contains
statements similar to the following:

If {file.FIELD} = "text string"

Make sure that the text strings used in the formula match values that
actually exist in the new data.

Deleting formulas

When a formula is created and added to a report, the Report Designer:

Stores the specification for creating the formula, using the name you
assigned to it.

Places a working copy of that formula at the point you specify in the report.
A working copy is any occurrence of the formula in the report.

In order to completely delete formulas, you must delete the specification and
all working copies of the formula.

578

Crystal Reports 2008 SP3 User's Guide

Using Formulas

22

Deleting formulas

Advertising