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.