Filemaker Pro 10 TU692LL/A Manual Do Utilizador

Lesson 9

  

|

  Creating and running reports     63

In the Membership Fee Report, you want to see subtotals for fees paid by each type of member, New and 
Continuing, and to see a grand total of both groups’ fees at the end of the report. To accomplish this, you 
need to specify subtotal and grand total summary fields in the New Layout/Report assistant.

The summary field you will use is Membership Revenue, which has already been defined for you in the 
Sample file. Membership Revenue totals the fees entered in the Fee Paid field.

1. For Summary field, click Specify and select Membership Revenue from the list of available fields, then 

click OK.

2. For Category to summarize by, use the default value of Membership Type.

3. For Subtotal placement, use the default value of Below record group.

4. Click Add Subtotal to add the Membership Revenue field as the subtotal. This tells FileMaker Pro to 

create a subtotal of the membership fees that are paid beneath each membership category.

5. Click Next.

6. For Summary field, click Specify and select Membership Revenue from the list of available fields, then 

click OK.

This tells FileMaker Pro to use the Membership Revenue field in the grand total.

7. Click Add Grand Total to add the Membership Revenue field as the grand total at the end of the report. 

This tells FileMaker Pro to create a grand total of membership fees.

8. Click Next.