Tutorial
Table Of Contents
- Lesson 1 FileMaker Pro basics
- Lesson 2 Browsing information
- Lesson 3 Finding and sorting records
- Use quick find to search a database
- Find records based on criteria in a single field
- Find records based on criteria in specific separate fields
- Find records that match multiple criteria in the same field
- Find records that match a range of criteria in the same field
- Narrow your search
- Save a find request to use later
- Find records using a saved find
- Sort your found set
- Add a new record in List View
- For more information
- Lesson 4 Creating a database and entering records
- Lesson 5 Customizing what you see
- Lesson 6 Creating lists, mailing labels, and form letters
- Lesson 7 Simplifying data entry
- Lesson 8 Automating tasks with buttons and scripts
- Lesson 9 Creating and running reports
- Lesson 10 Charting data
- Lesson 11 Making databases relational
- Lesson 12 Sharing and exchanging data
- Lesson 13 Protecting data in FileMaker Pro
- Lesson 14 Backing up your databases
Lesson 9 | Creating and running reports 57
2. Move the pointer over the Company column heading, and click the down arrow. Choose
Field
> Hide Field to hide the repeated company data in the Company column.
The label you created on the Company field remains in Table View to identify the group field.
Your finished report displays:
1 the fee paid by each customer
1 subtotals of fee revenue by company
1 a grand total of fee revenue from all companies
For this report to display properly in Table View, data must be sorted by Company.
Right-click or
Control-click the
summary row
Choose Add Group Field
(Company)
Subtotals are based on
Company groupings
Grand total