OraFAQ Forum: Reports & Discoverer » Dynamic number format ???

Home » Developer & Programmer » Reports & Discoverer » Dynamic number format ???

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

Dynamic number format ??? [message #204165]

Sat, 18 November 2006 07:29

sudhir.sukumar
Messages: 52
Registered: August 2005
Location: India

Member

Hi

I think I have searched enough without luck. Can any one tell me if we can format the figures of a number colmn (adding & removing decimals) dynamically ??

Thanks

Report message to a moderator

Re: Dynamic number format ??? [message #204190 is a reply to message #204165]

Sat, 18 November 2006 12:55

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

Hi

you can change in Property pallette of the item ...

bye

Report message to a moderator

Re: Dynamic number format ??? [message #204192 is a reply to message #204165]

Sat, 18 November 2006 13:05

sudhir.sukumar
Messages: 52
Registered: August 2005
Location: India

Member

Hi Vikram

Thanks for responding.

If you have data spanning two(2) currencies, I want it to be formatted according to their decimals (which can be 2 or 3); but I have only one colmn to display both formats.

USD format should appear as 99.87
Tunisian format should appear as 99.870

If its a whole number, it should display 2 or 3 zeros depending on the changing currency.

Hope it clear. Thanks.

Report message to a moderator

Re: Dynamic number format ??? [message #204195 is a reply to message #204192]

Sat, 18 November 2006 13:35

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

Senior Member
Account Moderator

Do you have a way to distinguish whether you are about to display Tunisian or USA currency? If not, you should first find a way to do that.

Once you fix it, create a Format trigger for the field that displays this value which will look like this:

IF currency = 'Tunis' THEN
   srw.set_format_mask ('NNNGNN0D000');
ELSIF currency = 'USA' THEN
   srw.set_format_mask ('NNNGNN0D00');
END IF;

Report message to a moderator

Re: Dynamic number format ??? [message #204214 is a reply to message #204195]

Sun, 19 November 2006 01:17

sudhir.sukumar
Messages: 52
Registered: August 2005
Location: India

Member

Thanks a lot.

That solved my problem.

Report message to a moderator

Previous Topic:	Reprts Generating in the specified format... PLZ Help
Next Topic:	Kerning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 16:35:26 CST 2024