SAP Knowledge Base Article - Public

1915803 - Customized formulas that are set to round number fractions may round whole numbers instead of fractions in CR 2008

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

    1. Create a formula in formula workshop:(5890.50 - 24300.00)/abs(24300.00)*24300
    2. Right click on the field and select "format field"
    3. In "Number" tab. click "Customize"
    4. 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

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011, feature pack 03