Group by column count not working in data set expression by using API
<p><span style="color:#000080;"><span style="font-family:'Source Sans Pro', sans-serif;">Hi,</span></span></p>
<p><span style="color:#000080;"><span style="font-family:'Source Sans Pro', sans-serif;"> I'm using BIRT verison 4_5_0. I want to show count of records per group as sub total for every group. The data set column "</span>group_by_back_603_count" is created for that count. </span><span style="color:rgb(0,0,128);">Without use </span><span style="color:rgb(0,0,128);">setValueExpr() it's working fine.</span><span style="color:rgb(0,0,128);"> When I use </span><span style="color:rgb(0,0,128);">textdata.setValueExpr("\"Sub Total: \" + row[\"group_by_back_603_count\"]") </span><span style="color:rgb(0,0,128);">then the below exception will be occured. Because, data set column "</span><span style="color:rgb(0,0,128);">group_by_back_603_count_1" is created additionally while use </span><span style="color:rgb(0,0,128);">setValueExpr()</span><span style="color:rgb(0,0,128);">. </span></p>
<p> </p>
<p><span style="color:#000080;">"org.eclipse.birt.report.engine.api.EngineException: Column binding "group_by_back_603_count_1" has referred to a data set column "group_by_back_603_count" which does not exist."</span></p>
<p> </p>
<p><span style="color:#000080;">My code is:</span></p>
<p><span style="color:rgb(0,0,128);">CellHandle cell = (CellHandle) groupFooter.getCells().get(columnBean.getColumnIndex());</span></p>
<div><span style="color:#000080;">textdata = designFactory.newTextData(null);</span></div>
<div><span style="color:#000080;">textdata.setContentType("html");</span></div>
<div><span style="color:#000080;">textdata.setValueExpr("\"Sub Total: \" + row[\"group_by_back_603_count\"]");</span></div>
<div><span style="color:#000080;">cell.getContent().add(textdata);</span></div>
<div> </div>
<div><span style="color:#000080;">I want that either </span><span style="color:rgb(0,0,128);">data set column "</span><span style="color:rgb(0,0,128);">group_by_back_603_count_1" will not be created or to delete the created data set column </span><span style="color:rgb(0,0,128);">"</span><span style="color:rgb(0,0,128);">group_by_back_603_count_1". Thanks in advance.</span></div>
<div> </div>
<div> </div>