level-breaking graphs...

[Harry S.]

Hi everyone,
I am developing some reports that contain graphs whose underlying data comes from a group-by query that aggregates data by product lines and then calcs averages, mins, maxs. etc.

I was playing with the reporting chart wizard and on one occasion I got the wizard to ask me where/how I wanted the report to break. That is, if there are three products I would end up with a report displaying a like number of graphs (10 products, 10 graphs, etc).

I can no longer get to that step... What I get now is one graph (instead of one per product).

Anyone know how to tell Access where/how I want my graphs to level-break?

Thanks in advance!
Harry

 

[Duane Hookom]

Your graphs behave much like subreports. They have Link Master/Child
properties. You can filter the graph to the value of a field or fields in
your main report. This is demonstrated in At Your Survey reports at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

--
Duane Hookom
MS Access MVP
--

Hi everyone,
I am developing some reports that contain graphs whose underlying data comes
from a group-by query that aggregates data by product lines and then calcs
averages, mins, maxs. etc.

I was playing with the reporting chart wizard and on one occasion I got the
wizard to ask me where/how I wanted the report to break. That is, if there
are three products I would end up with a report displaying a like number of
graphs (10 products, 10 graphs, etc).

I can no longer get to that step... What I get now is one graph (instead of
one per product).

Anyone know how to tell Access where/how I want my graphs to level-break?

Thanks in advance!
Harry

 

[Mingqing Cheng [MSFT]]

Hi Harry,

I wanted to post a quick note to see if you would like additional
assistance or information regarding this particular issue. We appreciate
your patience and look forward to hearing from you!

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!


Sincerely yours,

Mingqing Cheng
Microsoft Developer Community Support