Home » Developer & Programmer » Reports & Discoverer » Thousand Seprator In XML (Oracle)
Thousand Seprator In XML [message #333638] Sun, 13 July 2008 23:53 Go to next message
paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan
Member
Dear Friends,

im designing layout in XML for Reports(oracle reports for R12)

1) How can i Add THOUSAND SEPRATOR "," for numeric values ?

waiting for reply
Re: Thousand Seprator In XML [message #333639 is a reply to message #333638] Mon, 14 July 2008 00:07 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
I would not do that. XML is for transferring data; thousands-separators are format.
Formatting is the job of the presentation software, in your case Reports.
Re: Thousand Seprator In XML [message #333640 is a reply to message #333638] Mon, 14 July 2008 00:15 Go to previous messageGo to next message
paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan
Member
so what should i do? help me out
Re: Thousand Seprator In XML [message #333645 is a reply to message #333638] Mon, 14 July 2008 00:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Convert your numbers to strings.

Regards
Michel
Re: Thousand Seprator In XML [message #333650 is a reply to message #333640] Mon, 14 July 2008 01:24 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
paradoxkhan wrote on Mon, 14 July 2008 07:15
so what should i do? help me out

Looks to me like I made that clear.
Of course, it all depends on who defines your XSD, but if you have the choice, send your numbers as numeric in the XML. Use Reports to format the numeric data.
Re: Thousand Seprator In XML [message #333660 is a reply to message #333638] Mon, 14 July 2008 01:35 Go to previous messageGo to next message
paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan
Member
see the attached picture... i want to add thosand seprator for numeric values... kndly if any one can explain it to me....
  • Attachment: numeric.JPG
    (Size: 28.45KB, Downloaded 135 times)
Re: Thousand Seprator In XML [message #333662 is a reply to message #333660] Mon, 14 July 2008 01:42 Go to previous messageGo to next message
paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan
Member
Im using thousand seprator in report builder but it is not displaying it in output... so i guess i have to use it within word XML
Re: Thousand Seprator In XML [message #333664 is a reply to message #333662] Mon, 14 July 2008 01:47 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
You made an error in Reports. Fix that instead of sending in false data.
Suppose I would want that data to be displayed. The thousands separator for my Locale is a dot. Reports can handle that, given you send your data as numeric.
Suppose you want to have a choice of displaying the trailing zeroes for the cents-values. Reports can handle that.
As soon as you add separators in the XML, your data will be a string; no formatting possible (without lots of hassle)
Re: Thousand Seprator In XML [message #333681 is a reply to message #333664] Mon, 14 July 2008 02:59 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't speak XML, but nevertheless - how does "Format Model" property of these numeric values look like? Did you set it?

Here's an example based on Scott's EMP table:

./fa/4622/0/

Salary column is formatted using NNNGNN0D00 mask. "G" is a group separator; using it, you don't have to worry whether this report will be OK if NLS settings change (check Frank's answer, saying that "the thousands separator for my Locale is a dot" - it might be comma somewhere else). "D" is a decimal separator.

In my opinion, numbers should be kept as numbers and formatted accordingly to your needs just for displaying purposes (such as report).
Re: Thousand Seprator In XML [message #333718 is a reply to message #333638] Mon, 14 July 2008 04:26 Go to previous messageGo to next message
paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan
Member
i have done.. it was soo simple..

1)change the type to Number(in MS Word)
2)Select the Format for Number's

thnks for your kind reply and your time Smile
Re: Thousand Seprator In XML [message #333721 is a reply to message #333638] Mon, 14 July 2008 04:31 Go to previous message
paradoxkhan
Messages: 92
Registered: April 2008
Location: Pakistan
Member
Thnks LittleFoot/Frank for Helping me out Smile
Previous Topic: Pls. help. Why have no output. (order by)
Next Topic: OLE OBJECT to report various PDF documents
Goto Forum:
  


Current Time: Sat Dec 03 14:22:50 CST 2016

Total time taken to generate the page: 0.26612 seconds