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 XILotus Notes 7Microsoft 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
Product
SAP Crystal Reports XI