The report is to go like this:

 

   Fees

      Fees - Adv (select acct# 1 for this)  - show summary

      Fees - Desig (select acct# 2 for this) - show summary

      Fees - Int (select acct# 3 for this) - show summary

 

         Nuts (select acct# 4 for this) - show summary

         Nuts Agency (select acct# 5 for this) - show summary

      Fees Nuts - sum of Nuts and Nuts Agency

 

      Fees - SO (select acct# 6 for this) - show summary

      Fees - ST (select acct#10 for this) - show summary

      Fees Waived (select acct# 11 for this) - show summary

      Fees - Xferd (select acct# 36 and 12 for this) - show summary

         Fee Charges - sum of Fees section

   Other Fees

      Charges - Other 3rd Party (select acct# 15-20, 22) - show summary

      Charges - Ops (select acct# 23) - show summary

         Other Fees - sum of Other fees section

 

Total Revenues (= Fees section total + Other Fees section total)

 

 

This is just a partial list.I have 11 pages of group, then accounts within each group with corresponding totals - depends when specified for subtotals within main groups.

 

I am calling "Revenues" a main group, while Fees are just one section of Revenues.  Within Fees, there is a little subtotal separated from the rest of the group, yet it is in the middle of the section for desired report layout.  This is, "Nuts".  The section is then continued , then, at the end of the group, "Revenues", there is a total line.

The next main group would be something like, Expenses.

 

This is very confusing to me, so I gave the first part as an example of the desired output.  Each line is to have summaries of each column for the specified account(s) for that line.  Also, each line shows a summary of:  Prior Year Actual, Current Year Annual Budget, Current Year YTD Budget, Current Year YTD Actual, etc..

 

I am not sure how to go about creating this report to get the desired results.