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
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.
1
2
3
4
5
6
7
8
1
3
5
7
2
4
6
8
Down first
Across first
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.
Creating and managing layouts and reports 6-9
4. In the Layout Setup dialog box, General tab, select Print in
<value>
columns, select options for the columns, then click OK.
To Do this
Specify the number of For Print in <value> columns, type a number
columns between 1 and 99.
Arrange records to flow Select Across first.
across the page first (left to
Use this option for reports like labels, to use the
right a row at a time)
fewest number of rows and preserve label stock.
Arrange records to flow Select Down first.
down the page first (top to
Use this option for reports like directories, where
bottom a column at a time)
you read from top to bottom, column by column.
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.
Manually resize column
S
amp
l
e co
l
umn
widths by dragging
To Do this
Interactively adjust the Drag the right column boundary (the vertical dashed
width of the columns 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 Choose View menu > Object Size. Position the pointer
adjust the width of the over the right column boundary and hold down the
columns mouse button (be careful not to drag the column
width). The column width is the second-to-last field
in the Size palette.