SAP Knowledge Base Article - Public

1244976 - Different data is returned each time a Crystal report is run

Symptom

  • All users access the same report
  • Each user gets different result when refreshing the report
  • The same query gives inconsistent result each time

Reproducing the Issue

  • Create 2 ODBC connections
  • Create a cross-table based on the Excel Spreadsheet and Lotus Notes
  • Run the report 

Environment Information

  • Crystal Report XI
  • Lotus Notes 7
  • Microsoft Excel

Cause

There is no relationship between the Lotus Notes and Excel tables. Crystal Report doesn’t know how the data from the tables are related.

Resolution

  • Go to Database Expert
  • Click on the Links tab
  • Link the tables accordingly

Keywords

Crystal, Lotus Notes, No Data return, different result, refresh, inconsistent data , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports XI