

Well let me show you a couple quick steps that'll make that possible. Now let's say though, that instead of showing the company and then the invoice details and then their summary let's say instead we just want to show the company and their summary when we can do it in the form of a ranking report for example. Also we happen to have a Script Trigger set up that will sort based on the break field so that the user doesn't have to do that.

If we go under Layouts to Part Setup we see that we've got Header, Footer and Body but we have a Sub-summary part already in place and the break field has been established as the company so that's why when we're in Browse Mode we see this list broken up by company. So what we're going to do here is go into Layout Mode first and kind of take a look at how this layout is set up. If that's something you're unfamiliar with I urge you to go check out the learning FileMaker 17 course and check out the reporting chapter first but if you already understand sub-summaries I think you'll find this technique to be pretty interesting. This technique is going to build upon an understanding of sub-summary reports in FileMaker.
