Help

FILEMAKER PRO HELP 1258
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 are creating a sorted report, include the fields you want to sort by. If you are creating
a report with grouped data, include the break fields. Even if you don't want sort or break
fields to appear in the body of the report, FileMaker
Pro needs them to structure the report
correctly. If you see in a later panel that the field you want isn't available, click Back to
return to this panel.
• After you finish the assistant, you have complete control over placing or removing fields or
portals in Layout mode.
• In a report with grouped data, add the break field twice if you want it to appear in the body
part as well as in the subsummary part.
Related topics
Creating a layout
Specify Grand Totals (New Layout/Report assistant)
If you selected Include Grand Totals in the Include Subtotals and Grand Totals panel, you can use
this panel to define how they appear.
To specify a grand total:
1. For Summary field, click Specify.
The Specify Field dialog box appears.
2. Choose a summary field from the list, or define a new summary field. (Only fields defined as
the summary field type are available in the list.)
• To define a summary field in the current table, click Add. See Options for Summary
Field dialog box (New Layout/Report assistant).
• To define a summary field in another table, choose Manage Database from the list. See
Defining summary fields.
Note You must have full access privileges to define summary fields.
To Do this
Include a field in
the report
In Available fields, double-click the fields you want, in the order you want them to
appear.
Or, select one or more fields, then click Move.
To choose a field from another table, first choose the table from the list of tables, and
then choose the field. You can also create a new field or table by choosing Manage
Database from the list of tables.
Remove fields
you've already
selected
In Fields shown on layout/report, double-click the field you want to remove.
Or, select one or more fields, then click Clear.
Change the order
of the fields in the
report
In Fields shown on layout/report, drag the double-arrow next to the field name to a
new position.