Home
Analytics
indian currency number format
arya
how to display indian currency number format(#,##,##,###) in birt
Find more posts tagged with
Comments
bricombs
Good Day
BIRT provides a wide range of built in formating for different currency. You can also design a custom format using the "Format Number" property if you are using a data reort item bound to a numeric date type.
For formatting text data in a text element you can use the following:
<VALUE-OF format="#,##,##,###">row["AmtPaid"]</VALUE-OF>
There is also a BIRT Formatter function if you are using a Dynamic Text Report Item.
arya
<blockquote class='ipsBlockquote' data-author="'bricombs'" data-cid="116457" data-time="1367600583" data-date="03 May 2013 - 10:03 AM"><p>
Good Day<br />
BIRT provides a wide range of built in formating for different currency. You can also design a custom format using the "Format Number" property if you are using a data reort item bound to a numeric date type. <br />
<br />
For formatting text data in a text element you can use the following:<br />
<VALUE-OF format="#,##,##,###">row["AmtPaid"]</VALUE-OF><br />
<br />
There is also a BIRT Formatter function if you are using a Dynamic Text Report Item.<br /></p></blockquote>
<br />
<br />
<br />
hi, <br />
<br />
I have tried on it ,.. but it is not working any other solutions,..
bricombs
Good Day
Could you please explain what you have tried and how it is not working. Do you have a small example report that shows the issue along with what you expect to see.
earthonclouds
<p>Hey bricoms..</p><p> </p><p>I tried to use the format as suggested by you for formatting a number fetched from the database table.</p><p> </p><p>E.g. </p><pre class="_prettyXprint">this.getStyle().numberFormat="#,##,##,##0.000";</pre><p>Now when I pass a number as 100001.000, it is being formatted as <strong>100,001.000</strong></p><p> </p><p> </p><p>Could you please advise a solution?</p>
