Database Reference
In-Depth Information
NOTE
If you have sharp eyes, then you may notice that the “Summarize repetitions” drop-down list is
available all the time, although the items in it don't do anything unless you've selected a repeating
field. Don't waste your time clicking them unless you're working with a repeating field. Just one of
those FileMaker mysteries for the cocktail-party circuit.
Advanced Subsummary Parts
So far you've been working with layouts that only contain a single Subsummary part. But
your layouts can have several subsummaries, both above and below the Body part. You may
even need a report that doesn't show the source data at all using a layout with no Body part
at all.
Multiple Subsummary Parts on One Layout
You can do some really creative reporting by adding multiple Subsummary parts. Right now
your layout groups by Status whenever you sort that way. But what if you want to group by
city or state instead? No problem. Just add two more Subsummary parts. Once again, the
same “Count of People” field you already have counts the groups appropriately, so you don't
need to add more fields to the layout.
Following the same basic steps you used in the previous section to add the first Subsummary
part, add two more. This time, though, attach the first to the State field and the second to the
City field. In both cases, opt to Print Above, just as you did in step 11 on
Summary Fields
.
