When I export my Crystal report to "Excel 97-200 - Data only", some row fields in the spreadsheet contain different data than the report shows. The wrong exported data is from other records in the group. When exported as a PDF the data is as it appears in the report. Why is the data incorrect in the spreadsheet?
Update. I have found that if I export using the "Excel 97-2000" selection (without the Data only option) that the spreadsheet contains the data as it appears in the report.