Skip to main content



      Home
Home » Archived » BIRT » Number format - complete zero suppress
Number format - complete zero suppress [message #774870] Wed, 04 January 2012 15:23 Go to next message
Eclipse UserFriend
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 15:47 Go to previous message
Eclipse UserFriend
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: Wed Jul 16 14:08:21 EDT 2025

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

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

Back to the top