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-5
Envelope
Use an Envelope layout to print the fields you select, arranged to print
on a standard “Number 10” business envelope.
Blank layout
Use a Blank layout as the starting point for a layout that you create
entirely from scratch, for example, a complex data entry screen. You
add the fields you want on the layout in Layout mode.
Keep these points in mind:
1 FileMaker Pro layouts are divided into layout parts, which are
areas on the layout that control how to display and print data, text,
and graphics. FileMaker Pro includes the body, header, and footer
parts as needed on a layout depending on the choices you make in the
New Layout/Report assistant. Columnar reports with grouped and
totaled data also have either subsummary or grand summary parts or
both. You have complete control over adding, removing, or
modifying layout parts after you complete the assistant. See “About
layout parts” on page 6-25.
1 If your layout doesn’t turn out the way you expect it to, you can go
through the assistant again. Remember to delete the layout that you
no longer need (see “Working with, duplicating, deleting,
or renaming layouts” on page 6-8).
1 In the New Layout/Report assistant, you can apply FileMaker Pro
layout themes to enhance the appearance of a layout or report and to
give all your layouts a consistent look. A theme affects
characteristics of the layout, including the background color, field
borders and fill, and text attributes in and outside of fields. A theme
does not control the placement or behavior of fields or objects. You
can apply themes only in the assistant.
1 If you include a field on the layout from another database (a related
field), you should understand the concepts in chapter 8, “Working
with related files.” Also, see “Deciding where to place related fields”
on page 6-18.
1 When you create a Table view and switch to Layout mode, you see
a Standard form layout. Table view is not a layout type, it’s an
arrangement of data, like View as Form or View as List (on the View
menu in Browse mode). You can choose to view any layout in Table
view by choosing View menu > View as Table.
1 If you’re designing a layout to be viewed on the Web using the
FileMaker Pro Web Companion, see “Setting up browser views” on
page 14-10.
Considerations when you create a Columnar list/
report layout
1 If you are creating a report with grouped data, you should think
about how you want the report to look so you can more easily
proceed through the assistant. The assistant asks you to specify the
field or fields that you want to group the data by. If you are including
subtotals or grand totals, you should also think about what fields you
want to summarize and define those summary fields before you
begin the assistant. See “About defining database fields” on
page 5-3. (If necessary, you can also define the summary fields
within the assistant.)