Crystal Reports for Eclipse Designer Guide

To create a summary formula

  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 Formulas, and click New.
  4. In the "Properties" view, in the Name box, type "RunningTotal".
  5. In the "Field Explorer" view, double-click RunningTotal.
    The Record Filter on the Formulas tab appears.
  6. On the Formulas tab, under RunningTotal, type the following formula:
    WhilePrintingRecords;
    CurrencyVar Amount;
    
    Amount := Amount + {orders.ORDER AMOUNT};
    This formula prints the running total of the values in the Order Amount field.
  7. Save the report.
  8. Place this formula in the Body section of your report to the right of the {orders.ORDER AMOUNT} field.



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