Tutorial

64 FileMaker Pro Tutorial
4. Scroll to the bottom of the report, right-click the grand total row, choose Part Color, then choose a
different color to emphasize the grand total in your report.
Your finished report lists the membership fee paid by each member, a subtotal of membership revenue
by company, and a grand total of membership revenue from all three companies.
For this report to display properly in Table View, data must be sorted by Company. If you sort the data
by a different field, you will not see the formatting changes you made in Table View.
5. Right-click any column heading, choose Reset Table View, then click Yes to clear the dynamic report
settings and re-display all fields from the Data Entry layout.
Use an assistant to create a report with grouped data
You can use the New Layout/Report assistant to create a report in a separate layout. When you create reports
in the assistant, you have the option of creating a script that will rerun the report to update the data it displays.
About layouts for subsummary reports
A layout containing a report with grouped data requires a number of elements to work properly.
Layouts designed for subsummary reports include:
1 a subsummary part in the report layout for each level of detail you want to break out.
1 a field or fields to group records by (break fields).
1 records sorted by these break fields, in the order the subsummary parts appear on your report layout.
The New Layout/Report assistant creates these structures and makes these settings for you.
Subtotals are based on
company groupings
Grand total