It sounds like when this report was created in 8.5, the developer went in to the query and modfied it manually. You could do that in 8.5 and lower. However, when Crystal v9 came out, there were some VERY significant changes to the underlying structure of the .rpt file and this was no longer allowed.
Reports where the query was manually modified will
not run correctly in the later versions of Crystal! From experience (@150 reports of experience a few years ago...) you'll have to recreate the report from scratch in 2011. What I ended up doing was
1. Open the older report in either the old version of Crystal or the new one so that I had access to the formulas and parameters.
2. Create a new report in the new version of Crystal.
3. Instead of joining tables, create a Command, which is just a SQL Select statement, using the correct SQL for the report.
4. For each formula and/or parameter in the old report, add the objec to the report then cut it.
5. Paste the object into the new report. Then edit the formula so that it points to the command instead of to the tables from the old report.
6. Add the objects to the new report, copying the format from the old report.
-Dell
IP Logged
