Crystal Reports for Eclipse Designer Guide

To create a running total in a list

  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, right-click Running Totals, and click New.
  4. Select the new running total.
    The running total settings are displayed in the "Properties" view.
  5. In the "Properties" view, in the Name box, type the name "TotalOrders".
  6. From the Summarized Field list, select {orders.ORDER AMOUNT}.
  7. From the Summary Operation list, select Sum.
  8. From the Evaluate Condition Type list, select On change of field.
  9. From the Evaluate Condition list, select Orders.Order ID.
    The running total will execute each time this field changes.
  10. From the Reset Condition Type list, select Never.
  11. Insert the running total field in the Body section of the report, to the right of {orders.ORDER AMOUNT}.
    On your report, each row in the running total column displays the current record value added to the previous values. This total continues, unbroken, through the 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/