beautypg.com

Specifying formulas – HP Intelligent Management Center Standard Software Platform User Manual

Page 559

background image

Note:

After you have completed the configuration outlined in the Developer's Guide,
you must return to Crystal Reports, point to the File menu, and select Options.
On the Formula Editor tab, go to UFL Support and select Java UFLs Only.

Specifying formulas

There are several different kinds of formulas in Crystal Reports: report,
formatting, selection, search, running total condition, and alert formulas. The
majority of formulas in a report are report formulas and conditional formatting
formulas.

Report formulas

Report formulas are formulas that you create to stand alone in a report. For
example, a formula that calculates the days between the order date and the
shipping date is a report formula.

Conditional formatting formulas

Formatting formulas change the layout and design of a report, as well as the
appearance of text, database fields, objects, or entire report sections. You
format text through the Format Editor. If you need to create a formatting
formula, you access the Formula Workshop from the Format Editor. See

Working with conditional formatting

.

Note:

If you open the Formula Workshop from the Format Editor, you cannot create
a different type of formula, nor can you modify or delete existing formulas.
You can, however, view any formula for reference.

Selection formulas

Selection formulas specify and limit the records and groups that appear in
a report. You can either enter these formulas directly or specify the selection
using the Select Expert. Crystal Reports then generates the record selection
and group selection formula. You have the option to manually edit these
formulas, but you must use Crystal syntax. See

Selecting records

.

Crystal Reports 2008 SP3 User's Guide

559

22

Using Formulas

Specifying formulas