Symptom
In the Crystal Reports 2008 Designer, customized formulas that are set to round number fractions to their nearest whole number may round whole numbers instead of fractions.
For example:
If we set the formula directly as :Round( (5890.50 - 24300.00)/abs(24300.00)*24300).
Preview the field, the data show as -18,409.00. this is incorrect. The correct data should be -18,410.00
Environment
Crystal Reports 2008 Designer
Reproducing the Issue
- Create a formula in formula workshop:(5890.50 - 24300.00)/abs(24300.00)*24300
- Right click on the field and select "format field"
- In "Number" tab. click "Customize"
- In the dropdown list of "Rounding",select 1 to round it to the nearest whole number or decrease the decimal place to the nearest whole number using the icon from the menu.
Cause
This issue has been identified as a bug and raised under Problem Report ID: ADAPT01439629.
Resolution
This issue has been addressed in SAP Crystal Reports 2011 Feature Pack 3.
Keywords
crystal reports, customized formulas, round number, fractions, whole numbers , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed