Help

Creating and managing layouts and reports
F
ILEMAKER PRO HELP 231
Footer: Appears at the bottom of every screen or page (unless you add a title footer). You can have
only one footer in a layout.
Any fields in the footer preview and print data from the last record on that page.
Title footer: Appears only once at the bottom of the first screen or page and replaces the normal
footer (if one is specified). You can have only one title footer in a layout.
Any fields in the title footer preview and print data from the last record on the first page.
Note In Browse mode, the title header, header, footer and title footer display the data from the
active record.
Summary layout parts
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. Summary parts include grand summary and
subsummary parts.
A grand summary part usually contains one or more summary fields that display summary
information (like totals) about all records being browsed.
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.
Note You may want to create the summary fields that you want prior to creating a summary part.
For more information, see
Defining summary fields.
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.
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.
Tip You can change the focus of a report by specifying a different break field for a subsummary
part. For example, in a sales report with a subsummary part containing a summary field for sales,
you can select Month for the break field to get monthly totals or Salesperson to get individual
performance totals.
Viewing summary data in Table View
When you view summary data in Table View: