Help

FILEMAKER PRO HELP 1268
• 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.
• When you create a Report layout, you have the choice of saving a script that switches to the
layout, and sorts the records (if specified). 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
> Manage Scripts.
• You can create a report that displays fields from left to right across the page, with field
names as column headings, as a simple list (formerly a predefined layout type known as the
List view layout). When you create the Report layout, do not include subtotals or grand
totals, and do not organize records by category. Save the layout, and then view the records
in
List View in Browse mode.
• If you plan on printing records in a list and the columns extend beyond the width of a page,
try doing the following:
• Reduce the field size or the font size for data in fields.
• Choose File menu > Printer Setup (Windows) or Page Setup (OS X). (In Preview
mode, you can also click Print Setup (Windows) or Page Setup (OS X) in the status
toolbar.) In the setup dialog box, change the page orientation to horizontal (landscape).
Or reduce the scale at which you print to less than 100%. If necessary, re-create the
layout with the New Layout/Report assistant after you set up your printer and page
options.
• Create several layouts that show fewer columns, and then print each layout separately.
• A Report layout described above arranges fields in columns. You can also arrange records
in columns, for example, to print a multi-column directory of names and addresses. See
Setting up to print records in columns.
Related topics
Creating a layout
Deciding where to place related fields
You can place fields from related tables either directly on layouts or in portals:
• Directly on layouts: Place related fields directly on a layout to display data from the first
related record, even when there are more than one related record that match the criteria of
the relationship. (The first related record that is displayed is determined by whether the
relationship specifies a sort order.)
• In portals: Place related fields within a portal on a layout to display data from all related
records that match the criteria of the relationship.
For example, you might do the following on an Invoice layout in an Invoices database:
• Place related fields on the invoice that displays data from the Clients database, such as the
client's identification number and contact information. (The match field is Client ID.) There is
only one record in the Clients database for each Client ID, so each related field on the
invoice displays the data for that client.
• Place a related field on the invoice that displays the most recent value from the Order Date
field in the Order History database. (Again, the match field is Client ID.) If the client has
placed more than one order, there are multiple records in Order History that match this
client's Client ID. By defining a sort order on the Order Date field when you define the