Home » Developer & Programmer » Reports & Discoverer » Dynamic number format ???
Dynamic number format ??? [message #204165] Sat, 18 November 2006 07:29 Go to next message
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
Re: Dynamic number format ??? [message #204190 is a reply to message #204165] Sat, 18 November 2006 12:55 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi

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

bye

Re: Dynamic number format ??? [message #204192 is a reply to message #204165] Sat, 18 November 2006 13:05 Go to previous messageGo to next message
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.
Re: Dynamic number format ??? [message #204195 is a reply to message #204192] Sat, 18 November 2006 13:35 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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;
Re: Dynamic number format ??? [message #204214 is a reply to message #204195] Sun, 19 November 2006 01:17 Go to previous message
sudhir.sukumar
Messages: 52
Registered: August 2005
Location: India
Member

Thanks a lot.

That solved my problem.
Previous Topic: Reprts Generating in the specified format... PLZ Help
Next Topic: Kerning
Goto Forum:
  


Current Time: Thu Dec 08 19:55:46 CST 2016

Total time taken to generate the page: 0.09033 seconds