Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Linking problem Post Reply Post New Topic
Author Message
prevell
Newbie
Newbie
Avatar

Joined: 24 Sep 2008
Location: United Kingdom
Online Status: Offline
Posts: 1
Quote prevell Replybullet Topic: Linking problem
     Posted: 24 Sep 2008 at 6:00am
I have an old report created in version 8 which included a simple link between to Pervasive Btrieve tables using fields of the same type (string) and length which worked fine but when opened using any later version the report doesn't display any data. I have tried all the various link options and by changing from an Inner to a Left Outer join I can get the fields from one of the tables to display but not both.
Any ideas what I'm doing wrongly?
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 24 Sep 2008 at 10:49am
There are some quirks when converting to a newer version for some types of database connections.  We ran into problems with our reports with Oracle connections because we'd edited the SQL to remove the table owner (which is different for each of our environments.)
 
Here's what I would try:
 
1.  After opening the older version of the report in the newer version of Crystal, do a "Set Location" on the report.  Save and try running.
 
2.  If that doesn't work, you may have to recreate the report from scratch (this is what we had to do...)  However, this is not as bad as it may seem because you can have both versions open and copy/paste objects from the old report into the new one - this is the easy way to get all of your formulas into the new report without having to open the formula editor to retype them.
 
-Dell
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum