S
S. OBRIEN
I have a simply table consisting of 4 columns. (1 primary key, 1 data field,
and 3 lookup fields) Primary Key, Location, Material Used, Problem, Problem
Severity
In my database, an entry is a problem is the material used is above a
certain threshold value. i have created a queury which makes a count of each
problem type in each region. then I have made a report, which is grouped on
region, lists each problem type and the count of times that problem has
occured.
i have 3 locations: greensburg, youngwood, and latrobe.
I have 4 problems: contoller malfunction, user error, material defect, other
My report looks something like this:
Region: Greensburg
Problem: Controller Malfunction 1 times
Problem: User Error 2 times
Region: Youngwood
Problem: User Error 3 times
Region: Latrobe
Problem: Material Defect 1 time.
The region line is a header and the problem info is in the details.
I want to be able to place a pie chart in the region footer for each
section, which will display the same information as printed. The report
lists all the data correctly, However the series of pie charts refuse to work
on grouping.
I get lots of blank charts. Can someone guide me into how to create a
repeating pie chart which will repeat in a section footer for every region I
have?
and 3 lookup fields) Primary Key, Location, Material Used, Problem, Problem
Severity
In my database, an entry is a problem is the material used is above a
certain threshold value. i have created a queury which makes a count of each
problem type in each region. then I have made a report, which is grouped on
region, lists each problem type and the count of times that problem has
occured.
i have 3 locations: greensburg, youngwood, and latrobe.
I have 4 problems: contoller malfunction, user error, material defect, other
My report looks something like this:
Region: Greensburg
Problem: Controller Malfunction 1 times
Problem: User Error 2 times
Region: Youngwood
Problem: User Error 3 times
Region: Latrobe
Problem: Material Defect 1 time.
The region line is a header and the problem info is in the details.
I want to be able to place a pie chart in the region footer for each
section, which will display the same information as printed. The report
lists all the data correctly, However the series of pie charts refuse to work
on grouping.
I get lots of blank charts. Can someone guide me into how to create a
repeating pie chart which will repeat in a section footer for every region I
have?