Help

FILEMAKER PRO HELP 1257
Notes and tips
• To select more than one field name in the field lists, Shift-click to select contiguous fields,
Ctrl-click (Windows) or Command-click (OS
X) to select non-contiguous fields.
• If you chose to include subtotals (in the New Layout/Report panel), FileMaker Pro will
subsummarize fields based on the report categories you choose in this panel. You will
specify how the subsummaries work in the Specify Subtotals panel later in the assistant.
(FileMaker
Pro uses the term subsummary to include not only subtotals, but also averages,
counts, and other summary data for a subset of records.)
• Container, calculation, and summary fields can't be break fields; they are dimmed in Report
fields.
• You can choose up to 10 break fields.
• For each break field you add, FileMaker Pro adds a subsummary part to the layout. After
you finish with the assistant, you can modify characteristics like pagination and page
numbering. See
Changing a layout part.
• Each break field appears before the group of records you're categorizing (in a leading
subsummary part). You can set a break field to appear after the detail records by changing it
to a trailing subsummary part. See
Changing a layout part.
• If you want only a summary report (with no detail records), you can delete the body part
after you finish the assistant.
Related topics
Creating a layout
Include Subtotals and Grand Totals (New Layout/Report assistant)
In this panel of the New Layout/Report assistant, you can design a report with grouped data, which
includes summary fields that total data by group (for example, total sales by region).
To include summary fields:
• Choose Include subtotals or Include grand totals, or both.
As you select different options in the assistant, the sample image on the right changes to reflect
your choices.
To omit summary fields from the report, click Continue without making any selections.
Note If you create a subsummary report, you can’t choose to wrap fields to multiple lines. If you
select more fields than will fit across the printed page, they extend beyond the page margin. Try
either changing the page orientation to horizontal (landscape), reducing the print scale to less than
100%, or manually adjusting the fields in Layout mode.
Specify Fields (New Layout/Report assistant)
In this panel of the New Layout/Report assistant, you select the fields that you want to include in the
report. The fields appear on the layout in the order you specify.