Home » Fusion Middleware & Colab Suite » Business Intelligence » Need help for number format (XML publisher)
Need help for number format [message #379072] Sun, 04 January 2009 07:52 Go to next message
shadab.biotech
Messages: 2
Registered: January 2009
Junior Member
Hi,
I need to modify the comma separated number format to decimal separated format of number in XML Publisher
ie 10,000.00 should be displayed as 10.000,00
I need to apply this transistion on a field that is calculating the sum of amount.

Thanks,
Shadab.
Re: Need help for number format [message #435485 is a reply to message #379072] Wed, 16 December 2009 07:45 Go to previous messageGo to next message
tukyunaaya
Messages: 5
Registered: December 2009
Location: India
Junior Member

i dont think this is possible. coz i tried may combinations but the report failed to generate in all the cases.

[Updated on: Wed, 16 December 2009 07:51]

Report message to a moderator

Re: Need help for number format [message #435548 is a reply to message #435485] Wed, 16 December 2009 12:14 Go to previous message
vamsi kasina
Messages: 2096
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Change the rtf code from "##,##0.00" to "99G990D00".
# -> 9 -- any number
, -> G -- Thousand Separator
. -> D -- Decimal Separator

By
Vamsi
Previous Topic: Amount coming as Date Format
Next Topic: report and Page header should be different ?
Goto Forum:
  


Current Time: Wed Nov 26 02:15:46 CST 2014

Total time taken to generate the page: 0.09269 seconds