Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Upgrade 8.5 Crystal reports to XI

Upgrade 8.5 Crystal reports to XI

Upgrade 8.5 Crystal reports to XI

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.

RE: Upgrade 8.5 Crystal reports to XI

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.

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

RE: Upgrade 8.5 Crystal reports to XI

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.


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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close