The following sections describe each layout part type.
Non-summary layout part | Description |
Top navigation | Appears at the top of every screen and can contain buttons or other controls to help users navigate the layout. The top navigation part cannot be scrolled or zoomed in or out, and this part does not print or display in Preview mode. Fields added to a top navigation part use data from the current record. You can have only one top navigation part on a layout. |
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. In Browse mode, the title header displays the data from the active record. 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). Use for titles or column headings (in columnar reports). You can have only one header in a layout. In Browse mode, the header displays the data from the active record. |
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. In Browse mode, the footer displays the data from the active record. |
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. In Browse mode, the title footer displays the data from the active record. |
Bottom navigation | Appears at the bottom of every screen and can contain buttons or other controls to help users navigate the layout. The bottom navigation part cannot be scrolled or zoomed in or out, and this part does not print or display in Preview mode. Fields added to a bottom navigation part use data from the current record. You can have only one bottom navigation part on a layout. |
•To display a top or bottom navigation part or a header or footer part in Table View, you must select each option in the Table View Properties dialog box.
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.
Summary layout part | Description |
Grand summary | Usually contains one or more summary fields that display summary information (like totals) about all records being browsed. |
Subsummary | 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 Advanced inserts the subsummary part. |
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. |
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 Advanced 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.