round issue in numeric column

[bubu2006]

Hi,

I have a report where I am printing a numeric column. I am using Oracle10g, Crystal Report10. The column name is Mynumber and data type is Number (20, 7). I know by default Crystal report rounds by two decimal point. Is there any way I can display the value the way it is? I mean if the value is .7892 I want to display .7892. I know if I convert this data type as char it will work. But without changing the data type can I write formula in decimal and rounding section of format field?

Thanks in advance,
bb

 

[Madawc]

Right-click on the field, Format Field. This lets you set them.

You can also display using ToText({value}, 4)

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[bubu2006]

This will not help. Because I can have value like
12.1
12.12
.123
12.1234
12.12345
12.123456
.1234567

 

[Turkbear]

Hi,
Did you try the formatting method?..You can have as amny digits to the right of the decimal as you need ( within reason)..

Be sure the # in Oracle actually has the values you think ( Just because it is defined as a Number(20,7) does not mean that ALL entries have all those digits..)




To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[bubu2006]

I can not fix the decimal pointer. I have changed my databse view.

Thanks.

 

[lbass]

Please my post in thread767-1235276 for a method of displaying different numbers of decimals.

-LB

 

[bubu2006]

Interesting. I have changed that in Oracle view. I will try your formula next time. Thanks a lot for you help.