User manual

6-28 FileMaker Pro User’s Guide
1 For more information about setting up layouts for web publishing,
see “Setting up browser views” on page 14-10.
1 To apply a color or pattern to a layout part, click the part label,
then, in the status area, choose from the fill color palette, fill pattern
palette, or both. (The color you specify for the body part also affects
the background of the table in View as Table.)
1 FileMaker Pro doesn’t display subsummary layout parts when you
specify View as List in Browse mode or Find mode. You only see
subsummary parts and subsummary data calculated correctly in
Preview mode or in a printed report (see the next section, “Viewing
or printing subsummary or grand summary data”). FileMaker Pro
also doesn’t display or print subsummary or grand summary parts
when you specify View as Table in any mode.
1 When viewing or moving objects on a layout, you might want to
move the part labels if they’re in your way. To flip part labels up or
down, in Layout mode, click the part label control at the bottom
of the window.
1 You can eliminate blank spaces in fields or parts when printing.
See “About removing blank space from printed data” on page 7-22.
Viewing or printing subsummary or grand summary data
FileMaker Pro displays subsummary parts and calculates
subsummary data correctly only in Preview mode or in a printed
report (see “Previewing data on a layout” on page 4-3).
Note You must define a summary field for each field you want
summarized. You then place these summary fields in the summary
layout part. To define a summary field, see “Defining summary
fields” on page 5-6.
After you have added a grand summary or subsummary part:
1. On the layout, drag the summary field into the grand summary or
subsummary part.
See “Placing and removing fields on a layout” on page 6-15.
2. If you have a subsummary part, sort the found set by the break
field you specified when you created the part (see “Sorting records”
on page 3-8).
3. Choose View menu > Preview Mode.
Keep these points in mind:
1 When you use the New Layout/Report assistant to create a layout,
you can choose to create a ScriptMaker script to perform the
specified sort on the break field and then switch to Preview mode.
You can also define a script yourself to automate this (see “Creating
scripts: an overview” on page 10-3).
1 Use the script generated by the New Report/Layout assistant to
view or print a subsummary report (report with grouped data and
totals).
1 When you view records as a list in Browse mode (View menu >
View as List), subsummary parts aren’t displayed. To see subsummary
parts when viewing a layout as a list, switch to Preview mode or print
the list.
1 You can have only one leading and one trailing subsummary part
based on the same field.
1 If you’re having trouble getting summary information to display or
print, see the troubleshooting section in the FileMaker Pro onscreen
Help. Choose Help menu > Contents and Index, click the Index tab and
type subsummary reports.
Place a subsummary part,
containing only the Agent
Name field, above the body to
place the agent name in front
of that group of records
Use a grand summary to view the total
sales for all agents in the company
Place a subsummary part,
which totals the sales for
each agent, below the body