Manage Decimal Places with a Parameter

stephou85

Hello everyone,

I have encounter this problem several times.
Do you know an easy way to manage the "decimal places" with a report parameter ?
The problem is that with the Format Number Property, for the Decimal places attributes, we can use a javascript expression to set the value.

Thanks
Steph

CBR

Hi Steph,

you can use a script but only in event handler to change the number format.

What you can do is:

Change the number format using the number format property of the BIRT designer. Just provide values that make sense (i m assuming that you can say which currency your values are at least)
Add script to the beforeFactory event of your report like the following:

var nf = "###0.";

for(i=0; i<params["decimalPlaces"].value; i++) {
nf += "0";
}

myNumberFormat = nf+"{RoundingMode=HALF_UP}";

I m assuming that you have a report parameter called decimalPlaces which is a Integer and contain the number of decimal places in your report.

Now click on each data element for which you want to change the number format. Click on Script and choose the onCreate event using the drop down box on the top. Now simply add this script:
this.getStyle().numberFormat = myNumberFormat;

That's all.