beautypg.com

HP Intelligent Management Center Standard Software Platform User Manual

Page 250

background image

The Formula Name dialog box appears.

4.

Enter the name you want to identify the formula, and then click OK.

The Formula Workshop appears with the Formula Editor active.

5.

Enter the following formula into the Formula text box:

{Orders_Detail.Quantity} * {Orders_Detail.Unit Price}

6.

Click Save and close to return to the Field Explorer dialog box.

Your formula is listed in the Formula Fields node.

7.

Drag your formula field to the right of the Unit Price field in the Details
section of the report.

8.

To subtotal your extension formula, right-click the formula field, point to
Insert and choose Summary from the shortcut menu.

The Insert Summary dialog box appears.

9.

Click Insert Group and create a group on the {orders.ORDER DATE}
field.

10.

Choose for each week as the group interval.

Note:

"The section will be printed" drop-down box will not be activated until you
choose the Order Date field.

250

Crystal Reports 2008 SP3 User's Guide

Sorting, Grouping, and Totaling

10

Subtotaling