Decimal places getting cut

I have a crystal report which loads its data via an Oracle View.  
Some of the fields are of type Number.  On these fields, Crystal reports is cutting the decimal places to two
e.g. 45.3674 is coming out 45.36.

I know there are methods of altering this based on formatting the field after you have displayed it in your report, but I am using the fields in a calculation formula so this is of no use to me.

How can I ensure that crystal brings in the true values of the number fields?


note:  I also came across the number formatting within the Crystal Reports Options, but this only changed it on my local machine.  I did not work on client machines.

obrienjAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
WHat you see on the view is controlled by the formatting that is set for the field/object on the report.

If you display 4 decimals and round to 4 decimals do you get the value you expect?
The underlying data should still be accurate.

mlmcc
0
obrienjAuthor Commented:
What if the field is not on the report???

As I said, the field is been used within a formula and not on the report directly.  This means I can't select the field and set the formatting.  Therefore I can not display 4 decimal places.
0
obrienjAuthor Commented:
This is quite urgent, does anyone know a solution?  
0
Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

obrienjAuthor Commented:
Response and solution found elsewhere as no further response here.  
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mlmccCommented:
What was the solution?

mlmcc
0
obrienjAuthor Commented:
Well, it wasn't even really a solution, but a work around.
If I used the CStr command within the function to convert the number to a text it would come out correctly.
See: http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_24440946.html#a24482476

0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.