From the course: FileMaker Pro Essential Training (2019)

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Creating subsummary reports: Aggregating Summary Parts

Creating subsummary reports: Aggregating Summary Parts - FileMaker Pro Tutorial

From the course: FileMaker Pro Essential Training (2019)

Start my 1-month free trial

Creating subsummary reports: Aggregating Summary Parts

In previous movies we talked about the role of a summary field that gives us information about a found set. You'll see here on the bottom of the report, I have this field called Total Summary. And that is giving us information on all 146 orders that are currently in the found set. Now, if I go into Layout Mode, I'll see that I'm also using a layout part called Sub-summary when sorted by. One curious feature is a Sub-summary when sorted by creates mini-found sets and since a summary field aggregates a cross-found set, it'll do the same for mini-found sets. As a matter of fact, I'm just going to throw this up here real quick. I'm going to create a copy by option dragging or in Windows you can Control-drag. And I just want to show you what happens when I put that onto a sub-summary part. Without having to do anything, without having to create a new field, you see that it's now giving me not only the aggregate of all records in the found set which happens to be all 146 invoices at the…

Contents