binding - BIRT report, how to bind currency property on a dataset to the number formatting of a label -

binding - BIRT report, how to bind currency property on a dataset to the number formatting of a label -

i creating bill in birt. have created template already, , have played around having column , heading indicate currency.

however have currency part of row formatting, in other words this:

$ 120,000.00

the currency ($) read database, , have part of dataset can used parameter. problem - not know if parameter can somehow bound formatting of label?

kind regards, harriet

this quite straight building dynamic number format. in eclipse designer, click info element containing currency number formatted -> script tab -> oncreate

for example, come in script (assuming dataset column containing currency named "currency"):

this.getstyle().numberformat=row["currency"]+" ###,##0.00 ";

binding report currency birt number-formatting