Changing query for Chart by Group.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am approaching with some trepidation my first attempt at creating a report
that includes a chart. In fact, 3 charts.

I understand that a chart is based on a query. So far, so good. Now, the
issue is I need the 3 charts on one page for each manager. There will be 1
to n managers, depending on the data.

The query I am using now to get the data is an SQL statement that summarized
the data for each manager. In the report, I will be grouping by manager and
specifying a page break for each group. Six rows of the data will be used for
charts. Two rows each for the charts which will have two data series.

And the question is, how can I tell the charts for each manager to use only
the rows for the current manager?
 
Thanks, Duane,

I check the site and it is not specifically addressed, but it did address an
issue that makes me believe that if i correctly structure my query I can get
it to work. I will look at the Link Master/Child and get my head around that.

I appreciate the quick response.
 
Back
Top