Print Page | Close Window

Tables already linked join type can't be chgd

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4972
Printed Date: 21 Apr 2025 at 1:10am


Topic: Tables already linked join type can't be chgd
Posted By: sandy
Subject: Tables already linked join type can't be chgd
Date Posted: 10 Dec 2008 at 1:43pm
I am modifying an existing report which has a subreport.  I am trying to add one additional table and I receive the following err:  If tables are already linked then the join type cannot be changed.  I tried removing the subreport for now hoping that would get rid of the message then clearing the link to the table I just added and then placing the LOJ link back.   At this point Crystal Reports stops and shuts down.   Any suggestions????


Replies:
Posted By: hilfy
Date Posted: 19 Dec 2008 at 1:18pm
First, have you verified the database recently?  If not, go to the Database menu in Crystal and select "Verify Database".  This will update the report's view of the existing tables.
 
Do you have Smart Linking turned on?  If so, I would try turning it off to see if that helps resolve the error.  To do this, select Options from the File menu (not Report Options!)  Go to the Database tab and un-check "Automatic Smart Linking".  You'll now have to draw your own link between the tables, but that's a safer way of handling links anyways.
 
If this doesn't resolve the issue, does the report use any commands instead of tables?  That might be contributing to the problem.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: sandy
Date Posted: 22 Dec 2008 at 5:27am
I verified the db.  Smart Linking was on.   I unchecked the box.  The link were still present, so I deleted them then redraw them.  When I went to click OK Crystal Reports stopped working and shut down.  As far as Report Commands I have never used them so I need to research as to where to find if they are being used.   Thanks for all your assistance so far!!!

Posted By: sandy
Date Posted: 22 Dec 2008 at 5:37am

There is nothing under the Add Command tree.

Posted By: disdp1
Date Posted: 29 Dec 2008 at 5:18am
Hilfy,
 
I have the same problem Sandy has and my post is under technical questions, posted the same week.
 
Turning off smart linking does not resolve this issue in crystal 10 (regedit hack).
 
I've replicated this issue on numerous subreports. In the query, the field selected is in the 'Select' part of the SQL, BUT the table reference is in not in the 'From' section of the SQL.
 
Additionally, I am not using commands in the reports.
 
 
 
 
 
 


-------------
Dave

Posted By: hilfy
Date Posted: 29 Dec 2008 at 6:44am
Have you tried deleting the subreport, saving the report file, closing Crystal, then reopening the report and editing it?
 
Do you have the latest service pack for Crystal 10?  You can find it here:
 
http://resources.businessobjects.com/support/additional_downloads/service_packs/crystal_reports_en.asp - http://resources.businessobjects.com/support/additional_downloads/service_packs/crystal_reports_en.asp
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: disdp1
Date Posted: 30 Dec 2008 at 4:35am
Hello,
 
Download and installed SP6 but that did not resolve the issue. It seems that only Subreports are affected by this issue. I can add tables and reference their fields in the root report w/o problems.
 
Since many of the subreports are quite complicated, redesigning them is not an option I'd like to follow.
 
I'm going to try upgrading to Verion 11 which we have inhouse. I'd be curious as to whether the parent application that calls the CR10 reports will have a problem w/ the new version reports.
 
I'll post as to the result of that experiment.


-------------
Dave

Posted By: sandy
Date Posted: 30 Dec 2008 at 5:31am
This is Sandy again.   With regards to the problem I was having ( -- I am modifying an existing report which has a subreport.  I am trying to add one additional table and I receive the following err:  If tables are already linked then the join type cannot be changed.)     We are currently using Xi and the report was done in an earlier version.  First, if necessary, how do I determine what version it was created in?  Second, if it doesn't matter and the report is not using commands please advise what I should be looking for next.   Thanks

Posted By: hilfy
Date Posted: 30 Dec 2008 at 6:57am

Sandy,

Have you applied the available service packs to your Crystal XI install?  I have not run into this issue with XI at all, but I'm on the Developer version of XI r2 SP3 (version # 11.5.9.1227 on the About Crystal screen).

Other that the things I've already mentioned, I'm basically stumped at this point.  If you have the service pack installed, you may have to open a case with SAP to determine what's happening.

 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: theotherdodge
Date Posted: 30 Dec 2008 at 12:03pm
I am having this same problem using XI.   Like Sandy, just wanted to add a simple field so I found the table and linked it and now I can't get it to run, even if I delete it.  ???

Posted By: disdp1
Date Posted: 31 Dec 2008 at 4:59am

Ok, Installed CR11 and had no resolution regarding the addition of data objects to an existing subreport.

Removed  subreport and rebuilt it. Worked ok when  initial definition of data query included new data object.
 
To bad this issue did not crop up earlier and business objects identified it as a problem and included a fix in a service pack.
 
Good luck to those w/ this issue.


-------------
Dave

Posted By: peterlafay
Date Posted: 19 Sep 2012 at 2:16am
I ran into this too, turns out the smart links response is correct, you have to disable it prior to adding the additional table though.
 
File -> Options -> Database -> Uncheck Automatic Smart Linking
 
After doing this then add the table, you should be able to populate the report again.

Posted By: hilfy
Date Posted: 20 Sep 2012 at 3:10am
As I like to put it, Smart-linking isn't smart.  When I install a new copy of Crystal, I ALWAYS turn it off and build the links myself.
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window