OraFAQ Forum: Forms » How to supress zeroes?

Home » Developer & Programmer » Forms » How to supress zeroes?

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

How to supress zeroes? [message #121605]

Tue, 31 May 2005 01:15

dhamayanthi
Messages: 17
Registered: April 2005
Location: India

Junior Member

Hi,

This is regarding with Oracle graphics builder. i need to show the x and y label in chart as 10,12,14 and there is a chance to get decimal numbers like, .0000043,.0000021 and .000123 etc.
i have given number format like, 99.99999 and it shows 12.00000 if 12, 10.00000 if 10. i want to show decimals, only if it has.

Please Help me,
Thanks,
Dhamayanthi K

Report message to a moderator

Re: How to supress zeroes? [message #121779 is a reply to message #121605]

Wed, 01 June 2005 00:22

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I have not worked with Graphics for years. But if I remember correctly, duplicate the value in to a character field and put all the zeroes in there that you like.

David

[Updated on: Wed, 01 June 2005 01:23]

Report message to a moderator

Re: How to supress zeroes? [message #121791 is a reply to message #121605]

Wed, 01 June 2005 00:52

dhamayanthi
Messages: 17
Registered: April 2005
Location: India

Junior Member

i am not getting u. can u give the details little bit descriptively.
Thanks,
Dhamayanthi K

Report message to a moderator

Re: How to supress zeroes? [message #121794 is a reply to message #121791]

Wed, 01 June 2005 01:24

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Can you mark the axes with a field different to that used for the data?

Use a to_char(num_fld,'99.000000') ... I believe that this format will give you the trailing zeroes that you desire.

David

Report message to a moderator

Re: How to supress zeroes? [message #121865 is a reply to message #121605]

Wed, 01 June 2005 09:17

dhamayanthi
Messages: 17
Registered: April 2005
Location: India

Junior Member

Actually, i have the list of values:
they are,

10,12,14.....
.000002,.000004,.000006.....

i have given format as 99.999999.

for former, graphics builder shows,
as 10.000000,12.000000 and etc.
for later, it shows
as .000001,.000004,.000006.
later is okay. but former is very much odd to see.

can u give soln to that?

Report message to a moderator

Re: How to supress zeroes? [message #121877 is a reply to message #121605]

Wed, 01 June 2005 10:21

A Ikramur Rahman
Messages: 81
Registered: May 2004

Member

dhamayanthi,

create a new dummy field for display purpose only and do like this:

IF your_actual_field < .01 THEN
your_display_field := your_actual_field;
ELSE
your_display_field := to_char(:your_actual_field,'99.99') ;
END IF;

Report message to a moderator

Previous Topic:	Converting all the feilds into Caps
Next Topic:	frm-10221

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 18 21:23:53 CDT 2024