Filemaker Pro 9 (43)

Question 1

This deck added 4-24-2014

1. What if you connect the SUB SUMMARY PART to the ZIP CODE FIELD?

Answer 1

they you get PER ZIP CODE totals.

Question 2

2. When you add a SUB SUMMARY PART to a REPORT, it acts like a cross between:

Answer 2

a TRAILING (or LEADING) GRAND SUMMARY and a BODY PART.

Question 3

3. How does the SUB SUMMARY PART behave in a REPORT?

Answer 3

It does NOT repeat for every record. but it does repeat: it shows up ONCE for each GROUP OF RECORDS.

Question 4

4. Any SUMMARY FIELDS you put on a SUB SUMMARY PART will AUTOMATICALLY:

Answer 4

CALCULATE based ONLY on the SUBSET OF RECORDS in question.

Question 5

5. Any SUMMARY FIELDS you put in a SUB SUMMARY PART appear in the report:

Answer 5

multiple times, so you get multiple SUBTOTALS. In other words, you can put the SAME fields in DIFFERENT PARTS to see different results.

Question 6

6. SUB SUMMARY PARTS are unique in TWO WAYS:

Answer 6

a. They show up ONLY in PREVIEW MODE.

b. They show up ONLY WHEN DATA is SORTED by the FEILD THEY’RE ASSOCIATED WITH.