Why don't display 0 in aggregate information [message #989875] |
Sun, 09 December 2012 01:53  |
Eclipse User |
|
|
|
Hi,
The version is 4.2.1. I use it in a windows7 32bit OS.
In a sales report every week, I group date by region to display sales subtotals by region. In Aggregation Builder, i use the SUM function to compute the sum. If there is no records in a region, then, it will not display 0, but nothing(a blank table cell). So, in script, I select the 'onCreate', then entry script statement as below,
if(this.getValue()==null){
this.setDisplayValue("0");
}
It will display 0 in report designer, but display nothing(a blank table cell) in IE or Chrome when i deployed the report in a Tomcat.
I greatly appreciate all help.
Thanks.
[Updated on: Sun, 09 December 2012 01:54] by Moderator Report message to a moderator
|
|
|
|
Re: Why don't display 0 in aggregate information [message #990010 is a reply to message #989898] |
Mon, 10 December 2012 13:15   |
Eclipse User |
|
|
|
Hi Michael,
I used the sample database to make a cross table report, as the sample of BIRT Report Developer Guide. When you click 'EXTENDED_PRICE_s...', and choose 'Script' in the editor, after that select the 'onCreate', then you will see script statements.
It displayed 0 by Preview in report designer. It displayed nothing(a blank table cell) in IE or Chrome when i deployed the report in a Tomcat, via the URL '.../MyApp/frameset?__report=/displaySample.rptdesign'.
Thanks!
Hunter.
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03442 seconds