Help

FILEMAKER PRO HELP 1259
3. Click OK.
4. For Grand total placement, choose Beginning of report, End of report, or Beginning
and end.
FileMaker Pro places the summary field vertically in line with the field the summary field is
based on.
5. Click Add Grand Total.
The grand total appears in the Grand totals list.
6. Repeat the above steps for each grand total that you want to add.
Notes and tips
• To remove a grand summary, select the grand summary definition in Grand totals, then
click Remove Grand Total or double-click the grand summary in the list.
• To change a grand summary, remove the grand summary definition and redefine it.
• When you define a grand summary in this panel, you are defining a grand summary part,
(leading, trailing, or both), depending on the placement you choose. After you finish with the
assistant, you can modify characteristics like pagination and page numbering. See
Changing a layout part.
• If you define more than one grand summary with the same placement, the order in which
you define the grand summary in the assistant determines the order of the summary fields
in the grand summary part in the report. You can change the order of the summary fields
after you finish the assistant.
Related topics
Creating a layout
Create a Script for this Report (New Layout/Report assistant)
In this panel of the New Layout/Report assistant, you can automate your report by creating a script
for it.
To have FileMaker Pro create a script to rerun this report:
1. Select Create a script.
2. Type a script name to appear in the Scripts menu, or keep the default name.
This is the script name that you will choose from the Scripts menu when you want to rerun this
report.
3. Optionally, select Run script automatically if you want FileMaker Pro to display an up-to-
date report each time you open this layout.
Notes and tips
• If your layout contains summary data but it doesn’t appear in the report when you run the
script, you might need to switch to List View or Table View.
• When you create a script, FileMaker Pro includes default steps, which you can modify after
you finish the assistant. For example, you can add or delete steps, delete or change the
script name in the Scripts menu, or create a button on the layout to run the script.