I have an access report that groups Income Statement account numbers into Revenue, COGS, Wages, Other Expenses. So each group has a subtotal with a grand total (profit) calculation at the very bottom.
I have to now add statistics to this data. My thought is that i can just treat statistics such as labor hours and covers similar to revenues and expenses and group them into a "Statistics" category, this would cause all statistics to show up in a different group which is perfect. Also i can write an if statement in the grand total (profit) textbox that would exclude the Statistics grouping from overall calculation.
The overall structure of the report is as follows:
Page Header (which is blank)
CenterName Header(Name of Restaurant)
Account Type Header (Revenue, COGS etc)
Account Number Detail (04001CashRevenue, 04002CompRevenue etc.)
Account Type footer (has subtotal for each Revenue and Cost category
Center Name Footer (has the net profit)
Page Footer (page number etc.).
I am attaching the snapshot as well.
My problem is that Statistics show up BEFORE the profit row obviously because Statistics is a grouping and profit is in the footer of CenterName category. I would like to have statistics appear below the profit line. Any ideas would be welcomed. I would like to avoid using a subreport for this category as it slows down the report generation process (and also is a mess to construct).