User manual
Table Of Contents
- Preface Learning how to use FileMakerPro
- Chapter 1 FileMaker Pro basics
- Chapter 2 Adding and viewing data
- Chapter 3 Finding and sorting information
- Finding records
- Finding text and characters
- Finding exact matches in text fields
- Finding numbers, dates, and times
- Finding ranges of information
- Finding data in related fields
- Finding records that match multiple criteria
- Finding empty or non-empty fields
- Finding duplicates
- Finding all records except those matching criteria
- Hiding records from a found set and viewing hidden records
- Viewing, repeating, or changing the last find
- Sorting records
- Finding records
- Chapter 4 Previewing and printing information
- Chapter 5 Creating a database
- Chapter 6 Creating and managing layouts and reports
- Chapter 7 Customizing layouts
- Chapter 8 Working with related files
- Chapter 9 Protecting databases with passwords and groups
- Chapter 10 Creating scripts to automate tasks
- About scripts
- Creating scripts: an overview
- About ScriptMaker steps
- Control script steps
- Navigation script steps
- Sort, find, and print script steps
- Editing script steps
- Fields script steps
- Records script steps
- Windows script steps
- Files script steps
- Spelling script steps
- Open Menu Item script steps
- Miscellaneous script steps
- Changing scripts
- Duplicating, renaming, or deleting scripts
- Importing scripts
- Listing scripts in the Scripts menu
- Using buttons with scripts
- Example of a ScriptMaker script
- Chapter 11 Using formulas and functions
- Chapter 12 Importing and exporting data
- Chapter 13 Sharing databases on a network
- Chapter 14 Publishing databases on the Web
- About publishing databases on the Web
- How users work with databases on the Web
- What you need to publish databasesontheWeb
- Publishing databases on the Web: an overview
- Enabling FileMaker Pro Web Companion
- Configuring FileMaker Pro WebCompanion
- Enabling Web Companion sharing
- Setting up browser views
- Testing your published database
- About browser views for web publishing
- Chapter 15 Using ODBC with FileMakerPro
- Appendix A Customizing FileMaker Pro
- Appendix B Backing up and recovering files
- Appendix C FileMaker Pro Quick Reference (Windows)
- Appendix D FileMaker Pro Quick Reference (Mac OS)
- Index
Creating and managing layouts and reports
6-27
Part types that are already on the layout are dimmed (only
subsummary parts can exist more than once on a layout).
4. If you’re adding a subsummary part, after you click Sub-summary
when sorted by, select the name of the field that you want to group the
records by (the break field).
When the records are sorted by the break field, all records with the
same value in that field are grouped so that FileMaker Pro can
calculate subsummary data. (For example, if you wanted to subtotal
sales figures for each region, the break field would be Region.) For
more information, see the next section, “Viewing or printing
subsummary or grand summary data.”
5. If desired, select page break and page numbering options.
See “Defining page breaks and numbering” on page 6-29.
6. Click OK, then click Done.
After you define a part, you can change its type, break field (if it’s a
subsummary part), and pagination options:
1. In Layout mode, choose Layouts menu > Part Setup.
2. In the Part Setup dialog box, select the part, then click Change.
3. In the Part Definition dialog box, make your changes.
Dimmed types are not available because either:
1 that part type already exists (only subsummary parts can exist more
than once on a layout)
1 the part you're changing is not in the right place on the layout (for
example, a title header must be at the top of the layout)
4. Click OK.
Keep these points in mind:
1 To quickly add a layout part, you can drag a part from the Part tool
on the status area to the position you want it on the layout. Or, you
can use the Insert Part button on the Tools toolbar (choose View
menu > Toolbars > Tools). After you place the part, you see the Part
Definition dialog box. Some parts must go in specific places (for
example, trailing subsummary parts must go beneath the body), so if
the type you want is dimmed in the Part Definition dialog box, click
Cancel and try again.
1 You can add fields, portals, graphic objects, and text to any layout
part. FileMaker Pro considers an object to be in a part when the top
of the object is in or just touching the part. For example, if the top of
a field touches the bottom division line of the header part, the field
displays and prints only in the header and not in the body.
Select the type
of part to create
Select options for
page numbering
and breaks
To change Do this
From one type of
part to another
Select a different part type. Changes you can make
depend on the part’s location and function.
The break field In the fields list, select a different field name.
Page breaks and
numbering
See “Defining page breaks and numbering” on page 6-29.
Part tool
Part tool and boundary
appear as you drag the
part onto the layout