OraFAQ Forum: Reports & Discoverer » Report Builder 10.1.2.0.2

Home » Developer & Programmer » Reports & Discoverer » Report Builder 10.1.2.0.2 (10.1.2.0.2)

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

Report Builder 10.1.2.0.2 [message #382256]

Wed, 21 January 2009 09:54

averion
Messages: 42
Registered: January 2009
Location: US

Member

Hello Experts,

I am using oracle reports(10.1.2.0.2).
I have a value which is stored in the database as 79.8 and I need to display it in a report as $0.798. Right now I am using the format mask as LNNNGNNNGNN0D00 but it is convertin it to $.80.Is there a way to do it other than by Trunc in the query itself.

Thanks

[Updated on: Wed, 21 January 2009 10:03]

Report message to a moderator

Re: Report Builder 10.1.2.0.2 [message #382259 is a reply to message #382256]

Wed, 21 January 2009 10:05

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

try LNNNGNNNGNN0D000 as a format mask

Report message to a moderator

Re: Report Builder 10.1.2.0.2 [message #382289 is a reply to message #382259]

Wed, 21 January 2009 15:07

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

Senior Member
Account Moderator

Certainly; three digits after the decimal character are required in this case.

However: if column value is 79.8 and you want to display it as 0.798, wouldn't you first have to divide column value with 100 in order to properly display it?

Report message to a moderator