SAP Knowledge Base Article - Public

1881830 - Reports totals are incorrect or inconsistent

Symptom

  • Crystal Reports Running Totals are incorrect
  • Crystal Reports Manual Running Totals are incorrect

Environment

  • Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013

Reproducing the Issue

  1. Refresh report with Running Totals set to "Evaluate on change of group"
  2. Observe inconsistent results for Totals value

Cause

If the evaluation (calculation) done at the lowest group level and records within the group are not sorted, then Crystal Reports will take for calculation the first record from the group in the order records came to Crystal Reports. The original order records are coming to Crystal Reports may depend on the database, driver, volume of data, connectivity type, etc.

Resolution

Records should be sorted on the lowest level:

  1. Go to Record Sort Expert
  2. Add unique identifier database field to the Sort Fields window

 

 

 

Keywords

wrong results, summary, MRT, instable, random , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013