Precision Error
Hi :
The result of a Sum function is bad. I expect to receive xxxx.80 and I receive xxxx.79. If I use a sql statement directly I receive the real result.
The report is simple. Just a master band and a master pie.
How Can I correct this problem ???
Regards,
Al
The result of a Sum function is bad. I expect to receive xxxx.80 and I receive xxxx.79. If I use a sql statement directly I receive the real result.
The report is simple. Just a master band and a master pie.
How Can I correct this problem ???
Regards,
Al
Comments
Maybe your database's and FR's rounding methods are different. The proved technique for me is retrieving the numeric fields from the database in the desired precision. For example I retrieve currency fields from FireBird with NUMERIC(12,2) format. In this way values summed by the reporting engine and the database engine always the same.
Regards:Alex