Changing query for Chart by Group.

[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?

 

[Duane Hookom]

If I understand correctly you use the Link Master/Child properties of the
chart control. This is much the same as using the same properties on
subforms and subreports. You might want to check for some chart issue tips
at ACG Soft's pages http://ourworld.compuserve.com/homepages/attac-cg/.

 

[Guest]

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.

 

[Duane Hookom]

The reason I suggested the site was because of the issue. Good luck.

 

[Guest]

Thanks again, Duane.

The reason I suggested the site was because of the issue. Good luck.