Home » Developer & Programmer » Reports & Discoverer » Format Mask
Format Mask [message #269876] Mon, 24 September 2007 23:43 Go to next message
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.

Re: Format Mask [message #269886 is a reply to message #269876] Tue, 25 September 2007 00:28 Go to previous messageGo to next message
Messages: 20847
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
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: Fri Oct 28 15:27:20 CDT 2016

Total time taken to generate the page: 0.29800 seconds