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-25
About layout parts
FileMaker Pro layouts are divided into layout parts, sections of the
layout that determine how data in a field is treated and displayed. By
using parts, you can control how FileMaker Pro prints data, for example:
1 once for each record
1 only at the top of each page
1 only before or after groups of sorted records (for example, to
include a subtotal for each group of records)
Layout parts can contain fields, portals, buttons, text, and other
objects. In Layout mode, dotted horizontal lines mark the division
between layout parts, and the part label appears at the left end of the
bottom dividing line.
About layout part types
Each layout must have at least one part.
Note The New Layout/Report assistant automatically creates the
appropriate layout parts depending on the choice you make. You can
add, change, or delete layout parts after you finish the assistant as
needed. (See “Creating layouts and reports” on page 6-2.)
Body
Header
Subsummary
Trailing
Grand
Summary
Footer
Agent Name Product ID Qty Amount
David Michaels ET3 1 $29.95
David Michaels ET4 1 $32.25
David Michaels ET1 2 $73.90
David Michaels ET5 3 $98.85
Total $234.95
Sophie Tang ET6 2 $64.50
Sophie Tang ET7 5 $12.50
Sophie Tang ET2 2 $25.00
Total $102.00
Grand Total $336.95
Sales Report
A subsummary below the body
summarizes data for each
group of records sorted on the
break field (Agent Name)
Trailing grand summary
Footer
EveryWhere Travel Confidential June 1999
Layout part Description
Title header Appears only once at the top of the first screen or page and
replaces the normal header (if one is specified). In reports, can
be used to print a separate title page. You can have only one
title header in a layout.
A field in the title header displays data from the first record in
the found set.
Header Appears at the top of every screen or page (unless you add a
title header, which supersedes the header on the first page).
Use for titles or column headings (in columnar reports). You
can have only one header in a layout.
A field in the header displays data from the first record on that
page.
Body Each object you put in the body, including fields, text objects,
and graphics, appears once for each record in the found set.
You can have only one body in a layout.
Footer Appears at the bottom of every screen or page (unless you add
a title footer). You can have only one footer in a layout.
A field in the footer displays data from the last record on that
page.
Title footer Appears only once at the bottom of the first screen or page and
replaces the normal footer (if one is specified). You can have
only one title footer in a layout.
A field in the title footer displays data from the last record in
the found set.