I'm using SQL2005 and CR9.

 

When a value such as 1.20449 is rounded to 2 decimal places in CR9 it ends up as 1.20 in the report when IT SHOULD BE 1.21 ie. the Rounding Progression (logically) should look something like this :

 

a. 1.20449 (original value)

b. 1.2045 (4 decimal places)

c. 1.205 (3 decimal places)

d. 1.21 (2 decimal places)

 

The Original Value of 1.20449 resides in a SQL2005 Table, Money type field.

 

UR help greatly appreciated.

Thkx.

 

Is there a function / way to get that kind of "Progressive" Rounding (as illustrated) in Crystal Reports OR can a recursive rounding function be written in CR9?

 

e.g. something like this

 

    round(round(round(number2round, 2),3),4)

 

except that I do not know the exact number of decimal places for each number2round in each row as it is a result from a very complex formulae.

 

Any ideas please?