About layout part types

The following sections describe each layout part type.

Title header: Appears only once at the top of the first screen or page and replaces the normal header (if one is specified). In reports, can be used to print a separate title page. You can have only one title header in a layout.

Any fields in the title header preview and print data from the first record in the found set.

Header: Appears at the top of every screen or page (unless you add a title header, which supersedes the header on the first page). Use for titles or column headings (in columnar reports). You can have only one header in a layout.

Any fields in the header preview and print data from the first record on that page.

Body: Each object you put in the body, including fields, text objects, and graphics, appears once for each record in the found set. You can have only one body in a layout.

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:

•	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-had 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.