Crystal Reports for Eclipse Designer Guide

To create a display formula to display the variables

  1. In the "Field Explorer" view, right-click Formulas, and click New.
  2. In the "Properties" view, in the Name box, type "AmountDisplay".
  3. In the "Field Explorer" view, double-click AmountDisplay.
    The Record Filter on the Formulas tab appears.
  4. On the Formulas tab, under AmountDisplay, type the following formula:
    WhilePrintingRecords;
    CurrencyVar Amount;
    
    This formula displays the current value of the Amount variable at any time.
  5. Save the report.
  6. Place this formula in the Group Footer #1 section of your report.
    Because the Group Footer #1 section appears once for every group, @AmountDisplay will execute each time a group ends. So, the value stored in the Amount variable will be printed each time the group changes.

    Note: This formula prints the same value that @RunningTotal prints as the running total for the last record in each group. Because it is printing it in the Group Footer section, it acts as a group subtotal, not as a running total.
    On your report, each row in the running total column displays the current record value added to the previous values. The running total starts fresh with each new group, and the final running total for each group becomes the subtotal for that group.



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