Multiple Chart Report

  • Thread starter Thread starter Pete
  • Start date Start date
P

Pete

I wish to have a multiple chart report displaying 1 chart per Employee
displaying the Categories he has worked his hours in.

I have a query that when Run gives me the Data I expect from which I
build a Report with the Chart in the Detail Section. I have an
EmployeeID group which has the EmployeeID number in.

What I get is a Chart I want with all his hours displayed as required,
but then followed by the same chart a number of times depending on how
many Categories he has worked on e.g if he has 6 Categories, I get 6
charts the same, if he has done 2 Categories, I get 2 charts ans so on
for all employee's.

I have linked the Master & Child properties to EmployeeID

Any ideas?

Peter
 
Pete said:
I wish to have a multiple chart report displaying 1 chart per Employee
displaying the Categories he has worked his hours in.

I have a query that when Run gives me the Data I expect from which I
build a Report with the Chart in the Detail Section. I have an
EmployeeID group which has the EmployeeID number in.

What I get is a Chart I want with all his hours displayed as required,
but then followed by the same chart a number of times depending on how
many Categories he has worked on e.g if he has 6 Categories, I get 6
charts the same, if he has done 2 Categories, I get 2 charts ans so on
for all employee's.

I have linked the Master & Child properties to EmployeeID

Any ideas?
Click to expand...

Ever since the chart engine was changed from the version in Office 95 to the one
in Office 97 (and all newer versions) I have never been able to get the
Chart-Per-Record to work. Even getting the Chart-Per-Report-Instance to work is
spotty, but per-record just doesn't work any more in my experience. At least
not reliably enough to be trusted.

The problem is that the chart engine (apparently) updates asynchronously and the
Access report process does not wait for it to update. It just repaints the
previous chart over an over. Often you just get the chart shown with the sample
data you see when in the chart designer tool.

If you Google on the topic you should find some code on Microsoft's site in a
Knowledge Base article that is supposed to help. It basically tries to force
the chart to refresh in the code event for the relevant report section that the
chart resides in. In my experience using that code "helps". It reduces the
number of repeat charts, but does not eliminate them.

A lot of this might be determined by the speed and available resources of your
PC so even when you think you've got the problem tackled, there is no guarantee
that you won't see it in other circumstances or on other user's PCs.
 
Back
Top