Meter Charts - Accessing plotted data beforeGeneration
Hi all,
I have a major headache over the following problem.
My report is structured the following way:
There is a table, each table row contains a meter chart. Before drawing each meter chart I want to check which type of meter chart it is, in order to be able to identify how the region distribution on the meter chart should be structured.
Data Set example:
ID, Value, Area, MeterType
1, 45, North Carolina, B
2, 150, Georgia, A,
3, 75, Florida, A
4, 30, Virginia, B
So my output table is structured like:
Area Meter
North Carolina MeterChart of Type B
Georgia MeterChart of Type A
and so on
For making sure of getting the right data for the meter chart I also filter the data set on the ID of the current table row (iterating through the data set for each table row).
So there need to be two (or more) kinds of meter charts, and according to the type in column meter chart I want to structure the region distribution, because for each row item areas for green, yellow, white are reached at different levels.
I tried getting this done through accessing the DataSet at beforeGeneration level, but unfortunately that did not work and I have no idea what else I could try. Is it possible to access the DataSet of the chart at the beforeGeneration step? If so, how could I do that?
Any help would be highly appreciated!
Thanks in advance!
snowak