OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Format Mask

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Format Mask [message #269876]

Mon, 24 September 2007 23:43

aslme
Messages: 26
Registered: May 2006
Location: Pakistan

Junior Member

Dear I want to write Amount in this Format 500 or 5,000 or 50,000 or 5000,000 how can i do this in a Report Builder.

Thanks
Cheers

Report message to a moderator

Re: Format Mask [message #269886 is a reply to message #269876]

Tue, 25 September 2007 00:28

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

A natural way would be to set a desired format mask in the Format Mask field property; for example, 999G999G999D99 (note that I didn't use comma or full-stop characters, but more universal Group and Decimal separators).

Another way would be to apply the TO_CHAR function in the SELECT statement, such as

SELECT TO_CHAR(amount, '999G999G999D99') amount
FROM ...

Or, you could even create a formula column and return a character representation of a number, formatted as you desire.

Report message to a moderator

Re: Format Mask [message #288313 is a reply to message #269886]

Mon, 17 December 2007 01:08

white_phoenix
Messages: 19
Registered: November 2007

Junior Member

or put this NNNGNNNGNNNGNN0D00 at the format mask property of the field.

Report message to a moderator

Previous Topic:	Problem with running report from form
Next Topic:	how can i make reports from two queries ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 20:37:38 CST 2024