User manual

6-26 FileMaker Pro User’s Guide
To include summary data on a layout (for example, subtotals, grand
totals, averages, counts, and so on), you place summary fields in
summary layout parts (see “Defining summary fields” on page 5-6).
Summary parts include grand summary and subsummary parts.
1 A grand summary part usually contains one or more summary
fields that display summary information (like totals) about all
records being browsed.
1 A subsummary part usually contains one or more summary fields
that display “subsummary” information (like subtotals) for a subset
of records. The records are grouped (sorted) by values in another
field, the break field. Whenever the value of the break field changes,
the report “breaks” and FileMaker Pro inserts the subsummary part.
For example, to summarize each salesperson’s sales figures in a
database recording sales transactions, define a summary field
totaling the Sales field, and then create a subsummary part and place
that summary field in it (the break field is the salesperson’s name). If
you also want a count of that salesperson’s transactions, create a
second summary field counting the transactions, and also place it on
the same subsummary part. To get a grand total of all transactions,
place the sales summary field in a grand summary part.
Adding or changing layout parts
To add a layout part to a layout, first decide what kind of part you
need and where it should go. If you're defining a subsummary part
that summarizes a set of records, you also choose what field to group
or sort the layout by (the break field). Finally, define how the part
affects page breaks and page numbering.
To add a layout part:
1. In Layout mode, choose Layouts menu > Part Setup.
2. In the Part Setup dialog box, click Create.
3. In the Part Definition dialog box, select the type of layout part you
want. See the previous section, “About layout part types,” for a
description of each part type.
Layout part Description
Grand
summary
(leading or
trailing)
When you place a summary field in this part, the summary
field displays summary information for all records in the
found set. The grand summary part can be at the beginning
(leading) or end (trailing) of the report, depending on its
placement on the layout. You can have only one leading grand
summary and one trailing grand summary in a layout.
If you put another type of field in this part, FileMaker Pro
displays data from the first record (leading) or last record
(trailing) being browsed.
Subsummary
(leading or
trailing)
When you place a summary field in this part, the summary
field displays “subsummary” information for each subset of
records sorted by the specified break field. The subsummary
part can be before or after the body part, depending on the
placement on the layout. You can have multiple subsummary
parts in a layout.
If you put another type of field here, FileMaker Pro displays
data from the first record (leading) or last record (trailing) in
the group. Put the break field here to identify what subset of
records the summary is for.
A part includes the area between
the dotted lines that separate parts
Part tool
Part label