Groups' summary clubbed together

[Guest]

I have a report for sales organisation grouped by manager, supervisor, sales
rep. I have put group summary like total revenue, total number of orders in
each group footer, eg. 'supervisor' footer summarises all the information
about that supervisor derived from all sales reps under him. Now another
requirement is to have all the supervisors' summary information clubbed
together say, in the end of this report itself so that a manager doesn't have
to scroll through all the supervisors records to read each individual
supersisor's summary.So it should look like"
Supervisor Total Revenue Number of Orders
Sup1 45000 100
Sup2 50000 120
....
I attempted to copy the summary controls in the supervisor footer into the
manager footer alonmg with the manager summary. But these controls which have
been copied into the manager footer give the same information as the manager
controld themselves. I can produce a different report to achieve the desired
result but it is preferred to have it on the same report. How can this be
done? Thanks

 

[Marshall Barton]

I have a report for sales organisation grouped by manager, supervisor, sales
rep. I have put group summary like total revenue, total number of orders in
each group footer, eg. 'supervisor' footer summarises all the information
about that supervisor derived from all sales reps under him. Now another
requirement is to have all the supervisors' summary information clubbed
together say, in the end of this report itself so that a manager doesn't have
to scroll through all the supervisors records to read each individual
supersisor's summary.So it should look like"
Supervisor Total Revenue Number of Orders
Sup1 45000 100
Sup2 50000 120
...
I attempted to copy the summary controls in the supervisor footer into the
manager footer alonmg with the manager summary. But these controls which have
been copied into the manager footer give the same information as the manager
controld themselves. I can produce a different report to achieve the desired
result but it is preferred to have it on the same report.

The best way is to create your additional report and use it
as a subreport in the main report's footer section.