Can anyone tell me how to change the aggregation expression from the Aggregation Builder using Javascript?
I have a table with a group defined in the footer and a column that was defined using Aggregation Builder to have a function applied to an expression. E.g.
Aggregation Builder
Display Name: series1Agg
DataType: Integer
Function: COUNTDISTINCT
Expression: row["series1"]*2
Aggregate On: Group myGroup
What I am trying to do is to dynamically change the EXPRESSION using Javascript - anyone know how I can do that?
The XML of the report design for the expression looks like this:
<list-property name="arguments">
<structure>
<property name="name">Expression</property>
<expression name="value">row["series1"] * 2</expression>
</structure>
</list-property>
How can I access the contents of this stucture using Javascript??
Ok, so I have been able to use Javascript to change the aggregation function (by looking at the XML and guessing mostly), using this:
this.getDataBindings()[2].getStructure().setProperty("aggregateFunction", "Sum");
The XML for this was simpler:
<property name="aggregateFunction">COUNTDISTINCT</property>
Thanks in advance for any help,
dan
