Report summary fields
Constructing a report based on Events table, that has the Project info in the header, and all the Events listed below that are related to the Project [by Event::__kf_ProjectID].
Using portals for the Events>Revenue and Events>Expenses tables that are working fine. These are in the body of the report.
But in the header, or somewhere above all the event listings, need to have the *aggregate* Revenue and Expenses for each project, which are based on Summary fields in the Events>Revenue and Events>Expenses tables.
How can I get both in there?