1448524 - Weighted Average summary incorrect when exporting a report to MS Excel Data-Only from Crystal Reports

SAP Knowledge Base Article - Public

1448524 - Weighted Average summary incorrect when exporting a report to MS Excel Data-Only from Crystal Reports

Symptom

  • Incorrect values displays in MS Excel.
  • In MS Excel, when opening a report exported to MS Excel Data-Only, the Weighted Average summaries are incorrect.
  • Weighted Average summaries that are equal to zero in Crystal Reports doesn't export the correct value when exporting the report to MS Excel Data-Only

Environment

  • SAP Crystal Reports 2008
  • MS Excel

Reproducing the Issue

  1. In Crystal Reports, add a group to a report
  2. Create a formula to remove values, so we can have a weighted average equal to zero to reproduce the issue. ( Below is an example of a formula )

If {Amount} < 1000 Then 0 Else {Amount}

  1. Insert a Weighted Average summary for the group based on the formula created in step 2
  2. Ensure the report option “Convert Other Null Values to Default” is checked
  3. Preview the report and notice the groups where the weighted average is equal to zero
  4. Export the report to the format: Microsoft Excel (97-2003) Data-only
  5. Open the exported report in MS Excel and notice the incorrect values, notice where the weighted average should be equal to zero, it displays the previous weighted average.

Cause

  • The issue has been identified and logged under Problem Report ID ADAPT01386393 

Resolution

  • The issue is resolved in the following product update and above:
             
    • Crystal Reports 2008 and BusinessObjects Enterprise XI 3.1
      • Fix Pack 2.8 
      • Fix Pack 3.1 
      • Service Pack 4

Keywords

Crystal Reports, CR, MS Excel, Weighted Average, summary , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Bug Filed

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1