Quick Start

72 Getting Started Guide
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 69.
Generate a report with grouped data and totals
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.fp5.
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
Layout #1.
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.
Subtotals
Grand Total