Upgrade 8.5 Crystal reports to XI

[TracySHC]

My organization has just purchased Crystal Reports XI Release 2. We are attempting to migrate over our reports written in Crystal Reports 8.5. So far, the links to the files are shown in the Database Expert, but the SQL query for the report does not show the joins between the files. As a result, the 8.5 reports aren't working in XI.

Has anyone been able to resolve this problem without re-writing the 8.5 reports?

My apologies in advance - I know this must be a popular topic with those upgrading to XI, but I would appreciate all thoughts and links to past threads.

 

[Madawc]

This should really be placed in

http://www.tek-tips.com/threadminder.cfm?pid=149:

Crystal Enterprise is a distinct product. But to save time, I'll answer.

We went from 8.5 to 10. The handling of SQL is quite different. Save the old SQL code to a text file, and re-post using the more advanced system.

For version 10 and above (and probably also 9), you paste SQL commands into Crystal. Open [Database Expert]. Choose the database you want the date to come from. Choose [Add Command]. Paste in the SQL.

Expect a delay, because it insists on fetching the data before allowing you to go any further.

Madawc Williams (East Anglia, UK). Using Crystal 2008 with SQL and Windows XP

 

[hilfy]

I had this same issue because although we linked tables together in 8.5, we manually modified the SQL to take out the schema owner reference. To upgrade we had to recreate the reports from scratch. However, it wasn't that difficult, mainly because you can have both 8.5 and XI open at the same time. Here's the steps we took:

1. In XI, add the tables and the links.
2. For each of the formulas in the original report, put the formula object on the report in 8.5 (if it isn't already there) then copy it and paste to the report in XI. The formulas will be automatically created for you in XI.
3. Add the groups to the XI report. Also make sure that you have all of the same sections in the report in XI - size them
4. Copy and paste all of the objects except any lines from 8.5 to XI. Do this for all of the objects in a specific section at the same time - they'll paste into XI with the same formatting and positions. This should also bring over any conditional suppression/formatting.
5. Add any lines.
6. Go through the Section Expert in 8.5 and add any conditional formulas for things like suppression or new pages to the report in XI.

I found that it actually went fairly quickly using this process.

-Dell


DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com