<p><span style="color:rgb(0,0,0);font-family:monospace;font-size:12px;background-color:rgb(255,255,239);">Hi,</span></p>
<p> </p>
<p>my code is as below, it works well except big number.</p>
<p><span style="color:rgb(0,0,0);font-family:monospace;font-size:12px;background-color:rgb(255,255,239);">
</span></p>
<div>var colname = "sub" + myColName;</div>
<div>var myAggrArg = StructureFactory.createAggregationArgument();</div>
<div>myAggrArg.setName("Expression");</div>
<div>myAggrArg.setValue("row[\"" + myColName + "\"]");</div>
<div>var mysubtotal = StructureFactory.createComputedColumn();</div>
<div>mysubtotal.setName( colname );</div>
<div>mysubtotal.setProperty("dataType", "integer");</div>
<div>mysubtotal.setAggregateFunction("SUM");</div>
<div>mysubtotal.addArgument(myAggrArg);</div>
<div>colbinds.addItem( mysubtotal );</div>
<div>
</div>
<div> </div>
<p><span style="color:rgb(0,0,0);font-family:monospace;font-size:12px;background-color:rgb(255,255,239);">I </span><span style="background-color:rgb(255,255,239);color:rgb(0,0,0);font-family:monospace;font-size:12px;">dynamically created a subtotal, which is used to SUM() its corresponding INTEGER column,</span></p>
<p>the problem is that an error message "<span style="background-color:rgb(255,255,239);color:rgb(0,0,0);font-family:monospace;font-size:12px;">Can not convert the value of 2.87105668E9 to Integer type.</span>" occurs if the value of <span style="background-color:rgb(255,255,239);color:rgb(0,0,0);font-family:monospace;font-size:12px;">subtotal</span> is very big!</p>
<p> </p>
<p>As the statement mysubtotal.setProperty("dataType", "integer"), I think that's because of INTEGER overflow.<br>
Besides "integer" above, how many data types of number can BIRT support? And what are they?</p>
<p> </p>
<p>eg. using mysubtotal.setProperty("dataType", "float") instead of mysubtotal.setProperty("dataType", "integer")<br><br>
Thank you in advance!</p>
<p> </p>
<p> </p>
