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-3
4. When you have completed the series of panels, click Finish to
create the layout.
You can use the new layout right away, or further customize it using
the tools and commands in Layout mode (see “About working with
objects on a layout” on page 6-11, “About working with fields on a
layout” on page 6-15, and the next chapter, “Customizing layouts”).
Tip You can also duplicate an existing layout and customize the new
one to fit your needs.
About layout types
The following sections describe each of the layouts that you can
create with the New Layout/Report assistant.
Standard form
A Standard form layout is a good choice for data entry or onscreen
browsing. It contains the fields you select, each on a separate line, in
the order you specify, with field labels to the left of the fields. In
Browse mode, you see one record, or form, at a time (unless you have
switched from View as Form).
Columnar list/report
Use a Columnar list/report layout when you want to view or print
multiple records in rows (a list of records). You can define many
variations of a Columnar list/report with the New Layout/Report
assistant. You can create a layout with simple rows and columns of
data or a complex report with data grouped by specified values with
subtotals and grand totals.
A Columnar list/report layout contains the fields you select, in the
order you specify from left to right across the page, with field names
as column headings.
In the New Layout/Report assistant, you can choose to:
1 Limit the number of fields across the layout to the width of the
page (defined by the page margins, page orientation, and printer).
Fields wrap to multiple lines.
1 Group records by sorting. You can then subtotal, or subsummarize,
data in the groups (for example, group sales data by region, then
group subtotal sales for each region).
Field
labels
Fields you defined, in the order they
appear in the Define Fields dialog box
Simple columnar report layout
Columnar report with grouped data