Adding table grouping at a runtime programmatically?

newbie321

<p>Hi,</p>
<p> </p>
<p>How  do you add a table grouping at a runtime programmatically?</p>
<p> </p>
<p>below is the xml code equivalent for the table group, however I can not seem to replicate this .xml via java script.  I am able to set expression via </p>
<pre class="_prettyXprint">
.setExprKey()</pre>
<p>.  But how do I get to the cell (id=45)  through script?  Also, once I am at the cell level, do I just use </p>
<pre class="_prettyXprint">
.setProperty("resultSetColumn", "CITY")</pre>
<p><strong> </strong>method?<strong> </strong></p>
<p> </p>
<p>Thanks,</p>
<pre class="_prettyXprint _lang-">
<group id="34">
<property name="groupName">NewTableGroup1</property>
<property name="hideDetail">false</property>
<expression name="keyExpr" type="javascript">row["CITY"]</expression>

<header>
<row id="35">
<property name="backgroundColor">#400040</property>
<property name="color">#FFFF80</property>
<cell id="36">
<data id="45">
<property name="resultSetColumn">CITY</property>
</data>
</cell>
<cell id="37"/>
<cell id="38"/>
<cell id="39"/>
</row>
</header>

<footer>
<row id="40">
<cell id="41"/>
<cell id="42"/>
<cell id="43"/>
<cell id="44"/>
</row>
</footer>

</group>
</pre>

JFreeman

<p>You can add a table group by creating a TableGroupHandle and then adding it to the table using the addElement method of the TableHandle.</p>
<p> </p>
<p>For example:</p>
<pre class="_prettyXprint _lang-js">
var myTableGroup = reportContext.getDesignHandle().getElementFactory().newTableGroup();
myTableGroup.setKeyExpr("row[\"STATUS\"]");
myTableGroup.setInterval("none");
myTableGroup.setSortDirection("asc");

var myTable = reportContext.getDesignHandle().getElementByID(9);
myTable.addElement(myTableGroup, org.eclipse.birt.report.model.api.TableHandle.GROUP_SLOT);
</pre>
<p>Take a look at the attached report design with this code in place for reference.</p>