Show decimal places in Crystal Reports
Posted on 2004-11-22
I'm using Crystal Reports 8.5
I have a number field that can have a varying # of decimal places.
For example the field could be:
The maximum a # could be is: 999.999999 it can never be 1000.
In reality the # of decimal places can vary to be any #...
I want to show 6 decimal places.
If there are not 6 decimal places I want to show only 4.
I could make the data in the database have only 6 or 4 decimal places if that could help in a solution.
I have a formula that I thought would do it, but unfortunately I can't format the maximum #, the formula becomes invalid for that 6th decimal point, it only works till 5 decimal points, and I'm not quite sure why...