Charts generated from within a subgroup

[Jack Lamberton]

I have been trying to generate charts for each subgroup of
a group of records but the charts generated end up
including ALL records in the group instead of just the
subgroup selected/targeted. I use Chart Wizard to set up
charts in the subgroup footer.

Example:
SOURCE
Group A
...Subgroup a1
.....record a11
.....record a12
...Subgroup a2
.....record a21
.....record a22
Group B
...Subgroup b1
...Subgroup b2
etc.

DESIRED OUTPUT
1a) Detail records from Group a
1b) CHART for all records within Subgroup a1 in Subgroup
a1 Footer
1c) CHART for all records within Subgroup a2 in Subgroup
a2 Footer

2a) Detail records from Group b
2b) CHART for all records within Subgroup b1 in Subgrup b1
Footer...
2c) and so on...


But I ended up with the following UNDESIRED output:
***CHART for all records within Group A in every Subgroup
a1 and a2 Footers
***CHART for all records within Group B ....

Is there a way to really subgroup records for charting?
No problem if charting is not done.

We would appreciate advice and suggestions.

Thank you very much.

 

[Duane Hookom]

You can link Master/Child with graphs just like you would do with subreports
and subforms. You may need to add code to requery the graph in the On FOrmat
event of the section containing the graph. There is an example of this in a
report in "At Your Survey" found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp

 

[Jack Lamberton]

Duane,

Thank you for your reply.

From your example, I now know there is a way... but it is
still elusive to me. I was hoping to find an example to
add code to requery the graph in the On Format event in
the QstnID Footer section in the report
rptStatisticsWithGraphs but the On Format is all blank.
Did I miss something here? I checked all sections for the
On Format event --- all blank, too.

Whatever assistance you can provide will be greatly
appreciated.

Jack

 

[Duane Hookom]

I had created the report in Access 97 originally which didn't need to
requery. If you need to requery the graph, use code like:

Me.grphCtrl.Requery

 

[Jack Lamberton]

Duane,

You are truly a MVP - most valuable player in solving our
problem! Thank you veru much.

Happy Halloween!

Jack