U.M. (Windows)

8-12 FileMaker Pro User’s Guide
Exporting subsummary data
When you export subsummary data, you must specify how to sort and
summarize the records.
Note To export summary data, see the previous section.
1. Open a FileMaker Pro file and browse the records you want to export.
Use Find, Omit, or Omit Multiple, if needed.
2. Sort the records in the order you want them exported.
Sort on the break field (the field that groups the records), and then
switch to Preview mode to verify the subsummary results. (See
“Adding a summary part” on page 3-30 and “Sorting by summary
fields” on page 4-32.)
3. In Browse mode, choose Import/Export from the File menu, and then
choose Export Records.
4. In the Export Records to File dialog box, type a name, and then
choose a location for the file you’re exporting to.
Important If another file with the same name already exists,
FileMaker Pro replaces the data in it.
5. Choose a file type from the Save as type drop-down list, and then
click Save.
6. In the Specify Field Order for Export dialog box, select the fields to export.
For information about the Specify Field Order for Export dialog box,
see step 5 in “Exporting data from FileMaker Pro” on page 8-11.
7. To export subsummary values, select a summary field in the Field
Order list, and then click Summarize by.
To export Select this option
Unformatted values (for example, 3.7) Don’t format output
Values with the number, date, and time
formats from the current layout (for
example, $3.70)
Format output using current layout. Symbols and
other non-numeric values are exported as text.
You can’t select this option for SYLK, DBF, or
DIF formats.
Choose FileMaker Help Index from the Help menu, and then type:
E exporting, data
?