Creating Grouped Charts with Access Reports

[normalice]

I have a query that has three columns:
-# of defects
-location
-Reason

The location will always be one of four things. The reason will always be one of three things. I want to create a report that will create four different pie charts, one of each location, showing Reason vs # of defects.

Currently, what I have is this:

the report recordsource (in pseudo-code) is "select location from [query] group by location"

the chart recordsource (an embedded object in the report, again in pseudo-code) is "select reason, defects, location from [query] group by reason, defects, location"

the report groups each section by location and forces a new page after each location group

for the chart i have linked child and master fields as location

i get four pages of blank charts. if, however, i remove the master and child links i get four pages of identical charts - all of them include all four locations' data.

what am I doing wrong?

I could probably write some VB to take care of this but I don't want to. I'm not going to work here forever, and it would be nice if my successors didn't have to dig through all of my programs to figure out how to make changes if, say, we add a location or new reason category.

[normalice]

huh. almost 400 views and no replies. Either the solution is so embarassingly easy that no one wants to waste their time, or no one knows.

if the solution is very simple, someone please let me know and i'll look for it. If anyone reading this doesn't know, please say so: that way I know that at least there isn't a simple solution.

Thanks

[hype261]

Normalice,

I don't know about the other people here, but I try to stay away from creating Charts in Access. Other people might have had better luck, but I have always found it to be cumbersome and the charts themselves don't look as good as if I made them in Excel.

With that being said if my users what a chart of some data I usually take the data and dump it into excel and create the chart there. That way if they want to change my chart into a bar, pie, or scatter chart it is very easy for them and they don't have to bug me.

[normalice]

yes, i thought of that but the only problem i had with it is that it would result in double-saving data. If the data is already stored in access i would like it to stay there.

Of course, if I don't get an answer to this, excel is probably what I'll end up doing.