Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Chapter 5. Report Design > Grouping data to display totals

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 data item:

    Property Value
    TotalFields Amount
    GroupTotalFields Customer No.,Posting Date

  15. The properties window should look like the following screenshot:

  16. Save and close the report.


You are currently reading a PREVIEW of this book.


Get instant access to over $1 million worth of books and videos.


Start a Free Trial

  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint