Quick Start

Lesson 9
Creating and running reports
The process of retrieving and organizing data from a database is
called reporting. Summary reports present just the totals of your
data; they do not break information into smaller groups.
Subsummary reports, also referred to as reports with grouped data,
categorize information by a particular field or fields, allowing you to
group information hierarchically. This subsummarized information
can then be subtotaled, averaged, or counted.
In this lesson you will:
1 generate a report with grouped data
1 generate a report with grouped data and totals
Note You can install a fresh copy of the tutorial files at any time. For
Windows-based systems, see “Compact installation or Custom
installation” on page 9. For Mac OS systems, see “Custom
installation” on page 20.
Generate a report with grouped data
Look at a sample report
This example shows a report that groups the members by
membership type. The report has been saved to a script.
1. Open the Tutorial folder in the FileMaker Pro folder.
2. Open the Sample Files folder.
You should be here: FileMaker Pro\Tutorial\Sample Files.
3. Open Sample09.fp5.
4. Choose Scripts menu > Membership Type Report to generate the
membership type report.
5. Examine the resulting report.
First, notice that you are in Preview mode. Preview mode is
necessary to view summarized data on the screen. Second, notice
how the members are grouped by the membership type, and further
alphabetized by last name within each of these categories.
6. Click the Continue button in the status area to complete the script
and return to Layout #1.
This report groups
data by the
Membership Type
field, also referred to
as the break field