Eclipse Community Forums: BIRT » Number format

Help

Home

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

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

Number format - complete zero suppress [message #774870]

Wed, 04 January 2012 20:23

Tim Ames

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

Report message to a moderator

Re: Number format - complete zero suppress [message #774878 is a reply to message #774870]

Wed, 04 January 2012 20:47

Tim Ames

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.

Report message to a moderator

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 [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 24 21:44:30 GMT 2023

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter