User manual

3-10 FileMaker Pro User’s Guide
• 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. If you want to override the default
language for a sort, select Override field’s language for sort in the Sort
Records dialog box. (If you want to permanently change the field’s
default language, select the field in the Define Fields dialog box,
click Options, then click the Storage tab and select the default
language from the pop-up menu.)
Sorting records by subsummary values
If you have a subsummary report (a report with grouped data and
totals), the report is sorted by the category that produced the totals.
For example, if you have a report that subtotals sales by region, the
report is sorted by region (Example 1). You can also sort records by
subsummary values. For example, you can sort the sales regions by
their sales totals (Example 2).
In both examples, Total Sales is a summary field that gives regional
totals when grouped by Region.
Example 1:
Regions are sorted
in ascending order
Report with grouped
data and subtotals
Example 2:
Regions are sorted
in descending order
by Total Sales
Report with grouped data and subtotals,
sorted by subsummary values
This procedure is documented in Help. Choose Help menu > Contents
and Index, click the Index tab, and type sorting records.
For more information on reports with grouped data, see “Creating
layouts and reports” on page 6-2.