Help

FILEMAKER PRO HELP 1261
• Repeating fields sort by the value in the first repetition.
• The Reorder based on summary field option lets you sort grouped summary data.
Suppose you want to group data by region, then display total sales in each region from
highest to lowest rather than alphabetically by region. To do this, you can define a summary
field in the file (for example, Total Sales) and group the report by Region in the Organize
Records by Category panel of the New Layout/Report assistant. Next include and select the
Region field in the Sort order list of the assistant’s Sort Records panel, select Reorder
based on summary field, and choose the summary field Total Sales in the Select Field
dialog box.
• System formats affect the way numbers, dates, and times sort.
• When you define a text field, the default language for indexing and sorting text is
determined by the operating system on which FileMaker
Pro is running. You can override
the default language for a sort and specify a different language. See
Options for sorting
records. To permanently change a field’s default language, see Defining field indexing
options.
Related topics
Creating a layout
Specify Envelope Contents (New Layout/Report assistant)
In this panel of the New Layout/Report assistant, you place the fields and text that you want to print
on each envelope.
Important FileMaker Pro formats fields on an Envelope layout as merge fields. Merge fields are
enclosed by double angle bracket delimiters (<< and >>). Make sure to select these brackets along
with the field name if you move or delete a field name on the layout. Don't insert punctuation or other
text inside the brackets unless it's part of the field name.
To Do this
Place fields on the envelope In Available fields, double-click each field you want, in
the order you want them to appear. (Or, select one or more
fields, then click Add Field.)
To choose a field from another table, first choose the table
from the list of tables, and then place the field. You can
also create a new field or table by choosing Manage
Database from the list of tables.
Move a field to a new line In Envelope contents, click to place the insertion point
before the field you want to move (before the angle
bracket delimiters <<). Then press Enter (Windows) or
Return (OS
X).
Place text or punctuation between fields In Envelope contents, click where you want the text or
punctuation, then type what you want.
Remove a field from the envelope In Envelope contents, select the field name and the
delimiters (<< and >>), then press Backspace (Windows)
or Delete (OS
X).
Remove all fields and text from the envelope Click Clear All.