Difficult Sorting & Groups Issue

  • Thread starter Thread starter chuck.streb
  • Start date Start date
C

chuck.streb

I have created a report that groups items (a1,a2,a3,a4,a5) on to their
own graph. I have a graph in the Postion Header so that it will work
with Sorting & Groups.

Here is the problem. It works SOMETIMES. If I go into design mode and
drop ANY unbounded control it works. If I save it and run it it doesnt
most of the time.

When it doesnt work it plots all (a1,a2,a3,a4,a5) point on the first
graph.
When it does work it plots a1by its self a2 by its self ...

I have no clue what MICROSOFT access is doing.

Any ideas on how to fix this?
It feels like a race condition

Chuck

Report Record Source = StatsPlates
Sorting and Grouping = Position : Ascending, ID: Ascending
Graph Row Source = SELECT StatsPlates.Date, StatsPlates.Length FROM
StatsPlates ORDER BY StatsPlates.ID;
Link Child Fields = Position
Link MAster Fields = Position
 
ANSWER :

Through away the report which you copied the Chart into from the form
and start over.
Works great now.

Corrupted Report or Chart !
 
Back
Top