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.