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-9
When you set up records to print in columns, all the field values (and
labels, if specified) for one record are printed together in a block
(much like on a label), then all the values for the next record are
printed together, and so on. You see multiple columns only in Layout
and Preview modes and when you print (not in Browse mode or Find
mode).
You can choose to arrange columns across the page or down the
page.
To set up columns in a layout:
1. Choose a printer and print or page setup options.
FileMaker Pro considers the selected printer, and print or page setup
information when it calculates margins and other measurements on
the layout. See “Specifying a printer (Windows)” on page 4-2 or
“Specifying a printer (Mac OS)” on page 4-2.
2. In Layout mode, create a layout or choose a layout from the layout
pop-up menu.
It’s easiest to start with a Blank layout or a layout with no objects in
the body part.
3. Choose Layouts menu > Layout Setup.
4. In the Layout Setup dialog box, General tab, select Print in
<value>
columns, select options for the columns, then click OK.
5. On the layout, you see vertical lines indicating columns. Arrange
fields and other layout objects so they are contained in the sample
column on the left.
Down first
1
2
3
4
5
6
7
8
1
3
5
7
2
4
6
8
Across first
To Do this
Specify the number of
columns
For Print in
<value>
columns, type a number
between 1 and 99.
Arrange records to flow
across the page first (left to
right a row at a time)
Select Across first.
Use this option for reports like labels, to use the
fewest number of rows and preserve label stock.
Arrange records to flow
down the page first (top to
bottom a column at a time)
Select Down first.
Use this option for reports like directories, where
you read from top to bottom, column by column.
To Do this
Interactively adjust the
width of the columns
Drag the right column boundary (the vertical dashed
line at the right edge of the sample column). If you
widen the column, you see a medium-gray area that
indicates a “gutter” area that won’t print.
Precisely measure and
adjust the width of the
columns
Choose View menu > Object Size. Position the pointer
over the right column boundary and hold down the
mouse button (be careful not to drag the column
width). The column width is the second-to-last field
in the Size palette.
Manually resize column
widths by dragging
S
amp
l
e co
l
umn