Crystal Reports for Eclipse Designer Guide

To extend the price and subtotal the extensions

  1. Create a report using the Orders and Orders Detail tables from the Xtreme sample database.
  2. Select the Customer ID field from the Orders table, and the Product ID, Quantity, and Unit Price fields from the Orders Detail table, and place them from left to right in the Body section.
  3. On the "Field Explorer" view, right-click Formulas and click New.
  4. Double click My Formula.
  5. On the "Properties" view, click Name and enter a name for the formula.
  6. On the Formulas page, enter the following formula:
    {Orders_Detail.Quantity} * {Orders_Detail.Unit Price}
    
  7. Click the Layout tab.
  8. On the "Field Explorer" view, drag your formula to the right of the Unit Price field in the Body section of the report.
  9. Right-click Order Date, and click Group on Field.
  10. On the "Outline" view, expand Group Header 1, and click Section A.
  11. On the "Properties" view, click Subdivide By, and click Each Week.
  12. In the Body section, right-click the formula, and click Summarize.
  13. Move the summary field to the desired location in the group footer.
  14. In the "Properties" view, click Summary Operation, and click Sum.
    Your data will be sorted by date and grouped in one week intervals.



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