A
Aceware
(also accidently multiposted to .queries)
I'm used to the old Microsoft Graph ocx.
The beauty of this is that you could throw any cross tab query at it and it
would automatically set up all the appropriate series with a legend.
I'm trying to use the new pivot chart and I'm attempting to drive it with a
variety of cross tabs (one moment on the option form to drive the graph -
the user could choose faults by equipment category, another moment they
might choose faults by technician)
I am finding that it will not automatically handle different sets of columns
in the datasource driving it.
Eg one moment : Date, sensors, comms, power (where the last 3 columns
contain no of faults)
next moment : Date, Fred, Bill, Jim (where the last 4 columns contain no of
faults fixed by these technicians)
The form is bound to a query called qryGraph and the columns in this query
are changed dynamically by code.
I am at a loss to get started on some code that would dynamically examine
the field names in qryGraph, create bound fields on to the form(which the
pivot chart seems to insist on) and set up the pivot chart appropriately.
Could someone give me a starting point please.
Many thanks in advance
Tony Epton
I'm used to the old Microsoft Graph ocx.
The beauty of this is that you could throw any cross tab query at it and it
would automatically set up all the appropriate series with a legend.
I'm trying to use the new pivot chart and I'm attempting to drive it with a
variety of cross tabs (one moment on the option form to drive the graph -
the user could choose faults by equipment category, another moment they
might choose faults by technician)
I am finding that it will not automatically handle different sets of columns
in the datasource driving it.
Eg one moment : Date, sensors, comms, power (where the last 3 columns
contain no of faults)
next moment : Date, Fred, Bill, Jim (where the last 4 columns contain no of
faults fixed by these technicians)
The form is bound to a query called qryGraph and the columns in this query
are changed dynamically by code.
I am at a loss to get started on some code that would dynamically examine
the field names in qryGraph, create bound fields on to the form(which the
pivot chart seems to insist on) and set up the pivot chart appropriately.
Could someone give me a starting point please.
Many thanks in advance
Tony Epton