title: Decimals are being rounded in crystal reports and computing incorrectly
body: <p>Decimals are being rounded in crystal reports. The field(database field defined as float) Hours is being wrongly displayed in the crystal report. For example, 1.5 in the db is showing as 2.00, .75 shows as 1.00 and so on. There is also a field used to sum all the hours. That field is also picking the rounded values and summing incorrectly. I have formatted Hours as 1.00 and .01 in the formatting of crystal reports(for rounding &amp; decimals). I also have the common tab(in format editor) as LN_Hours. Nothing seems to be working. I tried using x-2 formula with no luck.
  Using crystal reports XI and SQL server MS 2012 and Visual studio 2003. Please throw some light on this situation! Thanks!</p>