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-11
Keep these points in mind:
1 FileMaker Pro doesn’t display subsummary layout parts when you
specify View as List in Browse mode or Find mode. You see
subsummary parts and subsummary data calculated correctly only in
Preview mode or in a printed report (see “Viewing or printing
subsummary or grand summary data” on page 6-28). FileMaker Pro
also doesn’t display or print subsummary or grand summary parts
when you specify View as Table in any mode.
1 To change the background color or pattern of the table, make sure
the fields are transparent, then change the color or pattern of the body
part (see “Adding or changing layout parts” on page 6-26). The
column headers pick up their font attributes (except the font color,
which is always black) from the first field in the tab order (see
“Setting the tab order for data entry” on page 7-8). You can’t modify
the background of the column headers.
1 If Include column headers is selected, users can resize columns or
sort by a column’s values (as long as they have the appropriate
access privileges) even if Resizable columns and Sort data when
selecting column are cleared by right-clicking (Windows) or Control-
clicking (Mac OS) the column header and choosing the appropriate
command from the context menu. See “Viewing records” on
page 2-2.
About working with objects on a layout
An object is a discrete element—a field, text, a graphic object (such
as an oval or imported picture), a button, or a portal (for displaying
rows of related records)—that you can select, move, resize, delete,
copy, format, and otherwise change. Place objects on a layout to
enhance its design.
For example, add the Client name and Line Item fields to a layout to
display data from those fields. Add the title “Invoice,” or emphasize
a group of fields by enclosing them in a rectangle to make the layout
easier to understand.
In Browse mode, objects look the same from record to record, while
field data changes to show the data in your database.
Working with the layout tools
For each type of object you work with, you use specific tools from
the tool panel or one of the toolbars (choose View menu > Toolbars).
Tool panel in Layout mode
Selection tool
T
oo
lb
ars