Help

FILEMAKER PRO HELP 1260
• If you want to include only a certain subset of the records in the database when you run this
report, you can edit the script to include a Perform Find script step after you finish the
assistant.
Related topics
Creating a layout
Viewing records as a form, list, or table
Creating and editing scripts
Sort Records (New Layout/Report assistant)
In this panel of the New Layout/Report assistant, you select the fields that you want the records
sorted by.
The sort hierarchy is determined by the order you specify. For example, if you want to sort by year
and then month, choose the Year field first, then the Month field.
If you are creating a report with grouped data and have selected one or more break fields, you see
them at the top of the Sort order list with a lock icon. You can't remove them or change their
position because the records must be sorted by those fields first for the report categories to display
properly.
Notes and tips
• By default, the field list in the Sort Records dialog box shows only the fields from the current
layout. If you want to sort using other fields, return the Specify Fields panel, choose a table
from the tables list above the list of fields, select additional fields, then return to the Sort
Records panel.
• Data sorts differently in different field types. See Sorting records.
To Do this
Include a field to sort by In Report fields, double-click the fields you want, in the order you want
them used in the sort hierarchy. (Or, select a field, then click Move.)
Remove fields you've
already selected
In Sort order, double-click the field you want to remove. (Or, select a field,
then click Clear.)
Change the order of the
fields to change the
sorting hierarchy
In Sort order, drag the double arrow next to the field name to a new
position.
Change the way
FileMaker
Pro sorts the
fields
With the field selected in Sort order, click
• Ascending order to sort in alphabetical order for text, lowest to highest
for numbers, and earliest to latest for dates and times.
• Descending order to sort in reverse alphabetical order for text, highest
to lowest for numbers, and latest to earliest for dates and times.
• Custom order based on value list and choose (or define) a value list
to sort in the order that matches a field's value list. For example, sort in
order by month.
Reorder the records
based on the values in a
summary field
In Sort order, select the non-summary field that you want to reorder based
on the values in a summary field. Click Reorder based on summary field,
and click Specify. In the Specify Field dialog box, select a summary field
and click OK.