Summarize Data Easily

[rwaugh]

Hello,

I have a report that contains many queries that, in the end, generate a multi-page report with the details of 16 measures.  There is a summary page which is basically just a count of all the compliant and not compliant files.  Is there a way to easily summarize the reports into a cross-tab, or chart (or anything for that matter) based on who the worker of the case is?  And then I can apply that to also get a summary based on the supervisors. 

Basically the data tab has a listing of all of the cases, various dates, the worker, the supervisor and compliance (based on the various dates).  I'd like to have a page for each of the 16 reports (or, 1 page that has all 16 in one summary - beggers can't be choosers) that lists the total number of compliant and not compliant files and the compliance %.  Something like (or if anything else is possible in terms of crosstabs and such):

Supervisor 1 - Compliant # - Not Compliant # - Compliance %
Supervisor 2 - Compliant # - Not Compliant # - Compliance %
Supervisor 3 - Compliant # - Not Compliant # - Compliance %

Any ideas?

Thanks,

Richard