Crystal Reports for Eclipse Designer Guide

To create a running total for a group

  1. Create a report using the Customer and Orders tables from the Xtreme sample database.
  2. Select the CUSTOMER_NAME field from the Customer table, and the Order ID and Order Amount fields from the Orders table, and place them in the Body section.
  3. In the "Field Explorer" view, select the {CUSTOMER.CUSTOMER_NAME} field, right-click, and click Group on Field.
  4. Right-click Running Totals, and click New.
  5. Select the new running total.
    The running total settings are displayed in the "Properties" view.
  6. In the "Properties" view, in the Name box, type the name "GroupRunningTotal".
  7. From the Summarized Field list, select {orders.ORDER AMOUNT}.
  8. From the Summary Operation list, select Sum.
  9. From the EvaluateCondition Type list, click For Each Record.
  10. From the ResetCondition Type list, click On Change of Group and accept the default group name.
  11. Place the running total field in the Body section of your report to the right of the {orders.ORDER AMOUNT} field.

    Note: If you want to view a grand total of each group, place the running total field in the Group Footer section of your report.



SAP BusinessObjects
http://www.sap.com/sapbusinessobjects/
Support services
http://service.sap.com/bosap-support/
Product Documentation on the Web
http://help.sap.com/