Tutorial

48 FileMaker Pro Tutorial
Generate a report with grouped data and
totals
In the previous exercise, you created a report that grouped data in
categories based on common field values. In this exercise, you will
create a similar report that also includes subtotals for each category
and a grand total for the entire report.
The subsummary report you will create:
1 groups the members by membership type
1 subtotals the fees collected for each membership type
1 provides a grand total of these fees
A report with grouped data and totals requires the same elements as
a report with grouped data: a subsummary part in the report layout
for each category, a field or fields to group records by, and a sort of
the database by these fields.
Two additional elements are also required:
1 a grand summary layout part
1 summary field(s) to display totals, averages, or counts
Create a report with grouped data and totals
To create the Membership Fee Report:
1. In Layout mode, choose Layouts menu > New Layout/Report.
2. For Layout Name, type Membership Fee Report.
3. Select Columnar list/report for the new layout type and click Next.
4. Select Report with grouped data and then select Include subtotals and
Include grand totals.
5. Click Next.
Select the fields used in this report
1. Select the first field to be used in this report, Membership Type,
and move it to the Layout fields list.
2. Select and move the Last Name field.
3. Select and move the First Name field.
This report groups data by
the Membership Type field,
also referred to as
the break field