Group charts and dynamic setting of axis and labels

karis

I have a a report where we are reporting bar charts for different variables. I am using a table with a Table group to generate the data set for each individual chart, which is placed in the Group Header. The binding to the table is to the Dataset and the charts inherit data from their container.

What I am trying to do is to set the Y axis label to the unit value ("testUnits") in the data set dynamically. I also want to set the Y axis scale to certain values depending on the measure ("testName") which is what the grouping is done by. I am trying to set global variables in the onPrepare method of the group header row so I can access these in the beforeGeneration method of the charts. Unfortunately I can't seem to access the row bindings this way.

reportContext.setPersistentGlobalVariable("unit", row["testUnits"]);

ReferenceError: "row" is not defined. I also get the same trying dataSetRow, data etc.

I don't think I can set these global variables in the onFetch method of the dataSet as it won't change for the various groupings, am I correct?

How can I access these values in the group?

Hans_vd

Hi Karis,
Try the onCreate method on the header row instead of the onPrepare method to set the global variable.
Does that work?