Home » Developer & Programmer » Reports & Discoverer » Format Mask
Format Mask [message #269876] Mon, 24 September 2007 23:43 Go to next message
aslme
Messages: 25
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
Re: Format Mask [message #269886 is a reply to message #269876] Tue, 25 September 2007 00:28 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
Re: Format Mask [message #288313 is a reply to message #269886] Mon, 17 December 2007 01:08 Go to previous message
white_phoenix
Messages: 19
Registered: November 2007
Junior Member
or put this NNNGNNNGNNNGNN0D00 at the format mask property of the field.

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


Current Time: Sat Dec 10 22:48:59 CST 2016

Total time taken to generate the page: 0.09942 seconds