beautypg.com

To edit a calculation formula, Header formulas, To edit a header formula – HP Intelligent Management Center Standard Software Platform User Manual

Page 456

background image

The pre-defined formulas are as follows:

Sum of

Difference of

Product of

Quotient of

Crystal Reports is equipped with a variety of functions to help you design
your own formulas.

To edit a Calculation Formula

1.

In the Calculated Member you would like to edit, right-click any cell
except for the header.

2.

On the shortcut menu, point to Calculated Member, and click Edit
Calculation Formula
.

The Formula Workshop appears.

3.

In the Formula Workshop, enter the desired Calculation Formula.

4.

Click Save and close to return to your report.

The Calculated Member displays the results of the new Calculation
Formula
.

Header Formulas

Header Formulas determine the visible row or column header for a
Calculated Member.

To edit a Header Formula

1.

Right-click the header of the Calculated Member you would like to edit.

2.

On the shortcut menu, point to Calculated Member, and click Edit Header
Formula
.

The Formula Workshop appears.

3.

In the Formula Workshop, enter your desired header name in quotations.

Note:

You can also control your header formulaically. A Header Formula must
return a string.

4.

Click Save and close to return to your report.

The Calculated Member header displays the result of the Header Formula.

456

Crystal Reports 2008 SP3 User's Guide

Cross-Tab Objects

17

Advanced Cross-Tab features