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.

Report message to a moderator

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: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Change the rtf code from "##,##0.00" to "99G990D00".
# -> 9 -- any number
, -> G -- Thousand Separator
. -> D -- Decimal Separator

By
Vamsi

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 09 11:52:54 CDT 2021
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.