A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

level-breaking graphs...



 
 
Thread Tools Display Modes
  #1  
Old July 16th, 2004, 02:21 PM
Harry S.
external usenet poster
 
Posts: n/a
Default level-breaking graphs...

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
  #2  
Old July 16th, 2004, 02:35 PM
Duane Hookom
external usenet poster
 
Posts: n/a
Default level-breaking graphs...

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/O...p#Hookom,Duane.

--
Duane Hookom
MS Access MVP
--

"Harry S." wrote in message
...
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


  #3  
Old July 20th, 2004, 06:44 AM
Mingqing Cheng [MSFT]
external usenet poster
 
Posts: n/a
Default level-breaking graphs...

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
---------------------------------------------------------------
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
print graphs in Access cqsu Setting Up & Running Reports 1 July 9th, 2004 02:05 AM
Word Password Encryption Level Paul General Discussion 0 June 11th, 2004 09:21 PM
Blank graphs Mark Mesarch Charts and Charting 0 June 10th, 2004 12:04 AM
Linked Graphs Paul W Smith Links and Linking 2 May 30th, 2004 04:47 AM
placing Excel graphs into Word table cells wlotto Charts and Charting 1 March 7th, 2004 05:29 AM


All times are GMT +1. The time now is 08:55 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.