Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Default number formatting
Migrateduser
Hello,<br />
<br />
I'm using BIRT 2.5.2,<br />
I have a strange issue related to the default number formatting. <br />
The system decimal separator is not used when the report Data value is of type decimal and float.<br />
same issue when using Dynamic Text instead of Data box.<br />
<br />
Only when a Data field is used and the type is set to String, the correct decimal separator is used!<br />
<br />
My PC is set to use German format so I'm expecting to have a decimal values separated by commas instead of dots.<br />
<br />
Ex. Expected : <strong class='bbc'>0,33</strong><br />
Dynamic text: <strong class='bbc'>Math.round(1/3*100)/100</strong> => <strong class='bbc'>0.33</strong> -WRONG<br />
Data field: <strong class='bbc'>Math.round(10*5/3*100)/100</strong> Data Type: <strong class='bbc'>Decimal</strong>or <strong class='bbc'>Float</strong> => <strong class='bbc'>0.33</strong> -WRONG<br />
<br />
Data field <strong class='bbc'>Math.round(10*5/3*100)/100</strong> Data Type: <strong class='bbc'>String</strong> => <strong class='bbc'>0,33</strong> - OK<br />
<br />
<br />
<br />
Any help is appreciated.<br />
Thanks in advance
Find more posts tagged with
Comments
There are no comments yet