User manual

12-8 FileMaker Pro User’s Guide
1 You can export data in container fields to FileMaker Pro format.
1 Exporting repeating field values to SYLK, WKS, or DBF formats
is documented in Help. Choose Help menu > Contents and Index, click
the Index tab, and type exporting,data.
Exporting subsummary data
You can export subsummary values like the subtotals generated by a
report with grouped data and subtotals. This process exports one
record for each category.
For example, if you have a report that totals sales by region, you can
export one value for each region. A report based on many records
might look like this:
The exported file might look like this:
For more information on generating reports with grouped data and
subtotals, see “Creating layouts and reports” on page 6-2.
Note To export grand summary data, see the previous section.
To export subsummary data:
1. Run the report that generates the subsummary values you want to
export, or find the records you want to include and sort them on the
break field (the grouping field used to categorize the records).
2. Choose File menu > Export Records.
3. In the Export Records to File dialog box, type a name, then choose
a location for the file you’re exporting to.
4. Choose a file type from the Save as type list (Windows) or Type list
(Mac OS), then click Save.
5. In the Specify Field Order for Export dialog box, select the fields
to export, including a summary field.
For more information about this dialog box, see step 6 in “Exporting
data from FileMaker Pro” on page 12-7.
6. Click Summarize by.
7. In the Summarize by dialog box, select one or more fields to
summarize by.
8. Click OK.
9. If you don’t want to include a grand summary amount with the
first record exported, click the non-italicized summary field, then
click Clear to remove that field from the Field Order list.
10. Click Export.
The file is
sorted by fields
listed here
A checkmark shows
the field is selected
Click a field
to select it
Subsummary values
for total sales by
region will export
Clear this field if you
don’t want to include a
grand summary value in
the first record