Generate multi section sub total form

[laguna92651]

I would like to replicate this Excel cash flow statement in Filemaker. Looking for some ideas on how to go about this. I may be making this more complicated than it needs to be. Should I place multiple portals in a list view form or is this all doable with a sub-summary report? The line items would not necessarily be the same for every account, in some cases there would be less or more items. Ideally I would like to collapse the various sections.

Edited July 14, 2016 by laguna92651

[webko]

This looks like an ideal candidate for a technique that isn't easy to understand first up, but is incredibly powerful: https://filemakerhacks.com/2016/04/27/virtual-list-reporting-part-1/

[laguna92651]

I've seen some of the Virtual List articles in the past, this will be a good reason to go through this series, thanks.