Help

Finding, sorting, and replacing data
F
ILEMAKER PRO HELP 130
Related topics
Sorting records troubleshooting
Sorting records by subsummary values
To properly display a report with grouped data and subtotals (also known as a subsummary report),
data must be sorted to display the appropriate break fields. If you have a subsummary report, data
in the report is grouped and displayed by the category that produced the totals. However, you can
specify a subsummary value to sort on to reorder data more logically in a report.
Note If you create leading or trailing groups in Table View, the data is automatically sorted by the
field that you used to group the data.
Suppose you create a report that subtotals sales by region. You can sort data in the report by region
(Example 1) or you can specify that records in the report are sorted by subsummary values, which
lists data by total sales (Example 2).
In both examples, Total Sales is a summary field that shows regional totals when sorted by Region.
Example 1: Report with grouped data and subtotals, not sorted by subsummary values
Example 2: Report with grouped data and subtotals, sorted by subsummary values
Unsort the records (return them to
creation order)
Click Unsort or, in Browse mode, choose Records menu >
Unsort.
Sort records according to a different
language than the one used for
indexing
Select Override field's language for sort, then choose a
language. To change the field's default language for sorting,
see
Defining field indexing options.
Place a new or changed record that’s in
sorted order into the adjusted order
after you
commit the record
Select Keep records in sorted order. When this checkbox is
deselected, new or changed records stay in the same position
in the sort order until you perform a find or sort the records by
different criteria.
Close the Sort Records dialog box
without sorting or saving changes to the
sort order
Click Cancel.
To Do this
Regions are sorted in ascending order
Region
A
B
C
D
Total Sales
800
150
300
1200