Eclipse Community Forums: BIRT » Number format

Home » Archived » BIRT » Number format - complete zero suppress

Number format - complete zero suppress [message #774870]

Wed, 04 January 2012 15:23

Eclipse User

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

Eclipse User

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:

-=] Back to Top [=-

Current Time: Wed Jul 23 01:16:18 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter