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

Comments

  • edited 12:20AM
    Hi!

    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

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.