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 #457529]

Tue, 25 May 2010 01:30

dhinendra
Messages: 58
Registered: September 2009
Location: Gurgaon,India

Member

hi
I am using NNNGNNNGNNNGNNDNN format in format mask so i am getting my value as 15,320,03.07 but i want to print it like 15,320,03.00
so what format i must used to implement this.

Thanks
Dhinendra

Report message to a moderator

Re: format mask [message #457532 is a reply to message #457529]

Tue, 25 May 2010 01:51

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

Senior Member
Account Moderator

Mask can't do that - you'll have to ROUND the value.

Report message to a moderator

Re: format mask [message #457533 is a reply to message #457529]

Tue, 25 May 2010 02:01

dhinendra
Messages: 58
Registered: September 2009
Location: Gurgaon,India

Member

hi littlefoot
round is still giving me the same output but i need to place zero's after decimal.means if value is like .89 then i want to print .00 instead of .89.

Thanks
Dhinendra

Report message to a moderator

Re: format mask [message #457535 is a reply to message #457533]

Tue, 25 May 2010 02:06

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

Senior Member
Account Moderator

So, you don't care about decimals at all? If so, truncate the number:

SQL> select trunc(104.23) t1, trunc(104.89) t2 from dual;

        T1         T2
---------- ----------
       104        104

SQL>

Report message to a moderator

Re: format mask [message #457537 is a reply to message #457529]

Tue, 25 May 2010 02:16

dhinendra
Messages: 58
Registered: September 2009
Location: Gurgaon,India

Member

hi littlefoot
yeah i don't care at all about value after decimal but i have to show .00 after value so is there any way to do this.

Thanks
Dhinendra

Report message to a moderator

Re: format mask [message #457538 is a reply to message #457529]

Tue, 25 May 2010 02:20

dhinendra
Messages: 58
Registered: September 2009
Location: Gurgaon,India

Member

actually littlefoot
i am using this concept in cheque printing that's why i need this condition to fulfill.

Thanks
Dhinendra

Report message to a moderator

Re: format mask [message #457545 is a reply to message #457538]

Tue, 25 May 2010 02:49

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

Senior Member
Account Moderator

OK then, truncate the value and apply format mask. For example: in a query you'd

select trunc(104.89) t1, trunc(25.34) t2
from dual

and apply format mask as NNNGNN0D00. Note zeros instead of Ns.

Report message to a moderator

Re: format mask [message #457546 is a reply to message #457529]

Tue, 25 May 2010 02:59

dhinendra
Messages: 58
Registered: September 2009
Location: Gurgaon,India

Member

hi littlefoot
now it is working i have used the trunc in my code and NNNGNNNGNNNGNN0D00 this format in format mask.

Thanks
Dhinendra

Report message to a moderator

Previous Topic:	spreadsheet
Next Topic:	Report display problem (merged by CM)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 20:51:24 CST 2025