Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Number format - complete zero suppress
Number format - complete zero suppress [message #774870] Wed, 04 January 2012 20:23 Go to next message
Tim Ames is currently offline Tim AmesFriend
Messages: 7
Registered: August 2011
Junior Member
I have a field from a data set in a BIRT table. What I want to do is simply display a blank (or nothing) if the value is zero - standard zero suppression. I cannot get it to work using Custom number format #,### - it always displays "0".

The number is a whole number - no decimals.

Any clues? Thanks
Re: Number format - complete zero suppress [message #774878 is a reply to message #774870] Wed, 04 January 2012 20:47 Go to previous message
Tim Ames is currently offline Tim AmesFriend
Messages: 7
Registered: August 2011
Junior Member
I ended up creating a column binding with this as the expression:

if (row["MY_NUMBER"] != 0) {
Formatter.format(row["MY_NUMBER"], "#,###")
} else {
""
}

I guess the java DecimalFormat does not do the trick in this case.
Previous Topic:Change query Text based on the database type from JS Script event handler
Next Topic:EMF ODA DataSource, Report Viewer and Classloader Problems
Goto Forum:
  


Current Time: Fri Nov 28 20:48:28 GMT 2014

Powered by FUDForum. Page generated in 0.01688 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software