I have used Number datatype in crystal report.
It has precision leve of 15 digits only.
All the digits after 15 digits are converted to ZERO (i.e. 0).
For example:
If I want to display a number: 8635468632416528.3652
then
crystal reports displays data as: 8635468632416520.0000
.
I am using oracle 10g database. I have checked my query as well, it is returning me the correct resultset.
I have also created a formula in crystal report and wrote this number,
then I came to conclusion that it is crystal report datatype precision problem.
Please let me know what should I do?
Is there any datatype in crystal report which can give greater precision?
Please advice?