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