Eclipse Community Forums: BIRT » Why don't display 0 in aggregate information

Help

Home

Home » Archived » BIRT » Why don't display 0 in aggregate information

Show: Today's Messages :: Show Polls :: Message Navigator

Why don't display 0 in aggregate information [message #989875]

Sun, 09 December 2012 01:53

Hunter Lee

Messages: 10
Registered: December 2012

Junior Member

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]

Report message to a moderator

Re: Why don't display 0 in aggregate information [message #989898 is a reply to message #989875]

Sun, 09 December 2012 17:07

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Can you attach a report showing your issue, that uses the sample database, so I can see the setup and test on it? Thanks.

Michael

Developer Evangelist, Silanis

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

Hunter Lee

Messages: 10
Registered: December 2012

Junior Member

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.

Attachment: displaySample.rptdesign
(Size: 18.83KB, Downloaded 499 times)

Report message to a moderator

Re: Why don't display 0 in aggregate information [message #990076 is a reply to message #990010]

Mon, 10 December 2012 18:12

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

Instead of using script, use the mapping option to set your condition. Click on your data element and go to the map section in the property editor. Make a condition for "value of this data item" equal to null -> 0. That should do it.

Michael

Developer Evangelist, Silanis

Report message to a moderator