Tutorial

50 FileMaker Pro Tutorial
6. Click Next.
Create a script to run this report again
1. Click Create a script.
2. Leave Script Name as it appears. Click Next.
3. Click View the report in Preview mode if it is not already selected.
4. Click Finish.
Your finished report should look like the report pictured on page 47.
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.
Look at a sample report
This subsummary report:
1 groups the members by membership type
1 subtotals the fees collected for each membership type
1 provides a grand total of these fees
1. To view the finished sample report, choose Window menu >
Sample09.
2. Choose Scripts menu > Membership Fee Report to generate the
membership fee report.
3. Examine the resulting report.
As in the previous example, the members are grouped by
membership type. Additionally, the fees collected for each
membership type are subtotaled beneath those members’ names, and
a grand total of all fees appears at the bottom of the report.
4. Click the Continue button to complete the script and return to the
Data Entry layout.
Subtotals
Grand Total