Chart report based on parameter query

[Guest]

I have a chart report based on a query which calculates average of revenue
for orders placed under supervisors across months. For this, I have grouped
by supervisor and month and calculated average of revenue. This is a
parameter query with the supervisor name as criterion. Another requirement is
to calculate these averages for managers who have supervisors under them. In
the same query, if I group by manager, the averages still remain the same
because averages are calculated at the lowest level. I can do this in 2
different reports based on 2 different queries, one for manager and another
for supervisor but I would prefer a single report. These manager and
supervisor criteria are passed to the query-report-chart through a dialog
form.
Can this be done in a single report/query? Basically I dont want the records
to be grouped by supervisor when the manager criterion is present

 

[Guest]

Try using a subreport - similar to a subform.

 

[Guest]

This worked...I included the manager subreport in the page header and the
supervisor report in the detail section. And included a macro say Macro1
which would hide the detail section when only manager criterion is present
and hide the page header when only the supervisor criterion is present. It
works as I had wanted it to...except when only the manager criterion is
present, it prints the manager subreport chart in a square box along with an
empty rectangle below the chart box contiguous with the chart box. When only
the supervisor criterion is present, it prints the supervisor chart without
such a rectangle beneath it. I have tried putting Macro1 in the 'On Open' and
then in 'On activate' property of the main report and then on the 'On Fomat'
property of the page header of the main report, everytime with the same
result. How can I get rid of this empty rectangle.