Grouping data to display totals

The easiest way to display totals in a report is to group records under specific criteria. This recipe will show you how to specify what fields to total and what criteria to use.

How to do it...

1. Create a new report using the Report Generation Wizard on table 21, Cust. Ledger Entry.

2. On the second wizard window, add the Customer No., Posting Date, and Amount fields.

3. On the third wizard window, set the sorting order to Customer No., Posting Date, Currency Code.

4. Click Finish.

5. View the sections for the report.

6. Add a second Header section.

7. Move the column labels to the Header section.

8. Add a GroupFooter section.

9. Move the textboxes from the Body section to the GroupFooter section.

10. Delete the Body.

11. Your sections should be as shown in the following screenshot:

    

12. Add the following code to the GroupFooter section:

    CurrReport.SHOWOUTPUT(CurrReport.TOTALSCAUSEDBY = FIELDNO("Posting Date"));
    

13. View the properties of the Cust. Ledger Entry data item.

14. Set the following properties on the...