We have a report that we have used for a long time and has always been fine. Today when we open it it says data will be lost because "Field name not known". So you click ok and look at the report in design and the report is missing a bunch of fields. You look at the Field Explorer and it only shows the first field in the table. This report links 2 tables. The linking field is the first field in both tables.
I try to re-map datasource and no luck. I close Crystal, open Crystal and create a new report, look at the same tables and all of the fields are there. Create similar report looking at same datasource, same tables, some of the same fields, and it works fine.
What is wrong with the original report and why won't it connect or show fields?