Home » Developer & Programmer » Reports & Discoverer » Format of number
Format of number [message #261668] Thu, 23 August 2007 05:22 Go to next message
dimis283
Messages: 38
Registered: July 2007
Location: greece
Member
I have a rather simple question.
I have a sum of columns at a query and I want to put this sum at a label (as &sum).
How can I change the format of this number, I know at text fields I will give the "NGNNNGNN0D00" format but at labels how can I do it?
With to_number function maybe at query, but how can I do it?
Re: Format of number [message #261675 is a reply to message #261668] Thu, 23 August 2007 05:34 Go to previous messageGo to next message
musman
Messages: 147
Registered: July 2007
Location: Lahore
Senior Member

ARE u saying label a simple text ..is that u mean?
Re: Format of number [message #261679 is a reply to message #261668] Thu, 23 August 2007 05:42 Go to previous message
dimis283
Messages: 38
Registered: July 2007
Location: greece
Member
At Label of reports we write text.
I want to write something like "The sum is &sum" and I want to give a format to this number not knowing the digits of the number.
I may give format at query but how, the examples I saw give numbers with known digits.
-----
edit
-----
At now I give this at query
SELECT to_char(255210.73, '999G999G999G999D99') FROM DUAL

[Updated on: Thu, 23 August 2007 05:52]

Report message to a moderator

Previous Topic: reducing the column size
Next Topic: send report by mail automatic
Goto Forum:
  


Current Time: Thu Dec 05 17:17:43 CST 2024