<p>I have a custom report generator application, that essentially uses the BIRT API to generate .rptdesign files. The .rptdesign files can then be used to generate a report using a currently attached data source (currently an SQLite database).<br><br>
I have a problem with empty/NULL data values in cross tables. If a data value is empty (or NULL) in the database, I want the corresponding cell to be empty in the cross table. Whatever I do, the value is always displayed as 0.00. This is misleading to the user, giving the impression that the stored value is zero rather than empty.<br><br>
Using <em>standard </em>tables (not cross tables), accessing the same data from the database gives me the desired result i.e. if the value in the database is empty then the cell in the table is also empty. The expression used for the structure in the bound data columns list for the table is....</p>
<pre class="_prettyXprint">
if (dataSetRow["MyData_Empty1"] != null) dataSetRow["MyData_Empty1"]*1.0+0.0
</pre>
<p>I have experimented with the measureExpression for the tabular-measure in the cube, and with the expression in the structure inside the boundDataColumns list property in the grid to no avail. The expression as used above which works fine for a table does not give the required result for a grid.</p>
<p> </p>
<p>Can I achieve the desired result using some javascript in the <expression> XML field? Or am I approaching this wrong and there is a better way?</p>
<p>I'm hoping I am missing a setting somewhere and it is something really simple that I have overlooked. Does anyone have any ideas?<br>
</p>
<p>Thanks.</p>
<p> </p>
