Help

Creating and managing layouts and reports
F
ILEMAKER PRO HELP 232
• The summary part is resized to display one row beyond the number of rows in the table.
• Fields placed on a layout in leading parts (leading grand summary or subsummary parts)
are aligned touching the bottom of the part.
• Fields placed on a layout in trailing parts (trailing grand summary or subsummary parts) are
aligned touching the top of the part.
• If a break field is placed in a subsummary part, it will always appear in the left-most column
in Table View. Break fields appear at the bottom of leading parts or the top of trailing parts.
• If more than one summary field is set for the same field, summary values appear together
with one value above the other.
• FileMaker Pro automatically adds field labels (such as Total) to subsummary parts to
identify the data displayed.
• If subsummary parts are assigned a fill color, the fill is applied only to the inside edge of the
right-hand column when the layout is viewed in Table View. The area to the right and below
the table appears in the color assigned to the body part in the layout.
Adding a layout part
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, you define how the part affects page breaks and
page numbering, as well as any background fill for the part.
To add a layout part:
1. In Layout mode, drag the Part tool in the status toolbar to the layout.
2. In the Part Definition dialog box, select the type of layout part you want.
See About layout part types for a description of each part type.
Part types that are already on the layout are dimmed. (Only subsummary parts can exist more
than once on a layout.)
3. If you're adding a subsummary part, after you click Sub-summary when sorted by, select
the name of the field that you want to group the records by (the
break field).
You can choose a field in another table by first choosing a table name from the tables list above
the list of fields.
When the records are sorted by the break field, all records with the same value in that field are
grouped so that FileMaker
Pro can calculate subsummary data. (For example, if you wanted to
subtotal sales figures for each region, the break field would be Region.) See
Troubleshooting
layouts with summary or subsummary parts.
4. Click OK.
Notes
• You can also add a part by choosing Insert menu > Part in Layout mode.
• When you add a layout part, its format is based on the theme applied to the layout. You can
apply a custom style to change the display attributes of the part (such as display a color
gradient as the part background). See
Creating new layout object, part, or background
styles.