User manual

6-6 FileMaker Pro User’s Guide
1 In order to view a report with grouped data and totals, you must
sort by the break field and go to Preview mode. The New Layout/
Report assistant lets you create a script to do this.
1 When you create a Columnar list/report layout, you have the choice
of saving a script that switches to the layout, sorts the records (if
specified), and pauses in Preview mode. The script is added to the
Scripts menu, where you can choose it to run the report in the future.
Verify that you’re viewing the found set that you want before
running the script. You can view or edit the script (for example, you
can add a Find script step) by choosing Scripts menu > ScriptMaker
(see “Changing scripts” on page 10-10).
1 A Columnar list/report layout arranges fields in columns. (For
information on arranging records in columns, for example, to print a
directory of names and addresses, see “Setting up to print records in
columns” on page 6-8.)
1 If you plan on printing a Columnar list/report and the columns extend
beyond the width of a page, try one or more of the following:
1 Reduce the field size or the font size for data in fields.
1 Change the page orientation to horizontal (landscape). Or reduce
the scale at which you print to less than 100%. See “Preparing to
print wide layouts” on page 4-2.
1 Create several layouts that show fewer columns, and then print
each layout separately.
1 If you’re having trouble getting the results you want for a report
with grouped data, refer to the onscreen Help available for each
panel of the assistant. Also, see the troubleshooting section in the
FileMaker Pro onscreen Help: choose Help menu > Contents and
Index, click the Index tab, and type subsummary reports.
Considerations when you create a Labels layout
When printing labels, you usually use either individual sheets of
labels, or a continuous-feed roll of labels (for dot matrix printers).
Because FileMaker Pro considers the selected printer and print or
page setup information when it calculates margins and other
measurements on the layout, you must verify these settings before
you create a Labels layout.
1. Choose the printer. See “Specifying a printer (Windows)” on
page 4-2 or “Specifying a printer (Mac OS)” on page 4-2.
2. Choose File menu > Print Setup (Windows), or File menu > Page
Setup (Mac OS).
3. In the setup dialog box:
1 For individual sheets of labels, select the size of the label sheets
(usually US Letter in the U.S. and A4 elsewhere), then click OK.