Crystal reports 11 incompatability with Crystal reports 10

Version 2
    Question

    Error: "Failed to retrieve data from database" when previewing a report

    "Database Connector Error: 'If the tables are already linked then the join type cannot change'"

    Answer

    Crystal have this:

     

    http://technicalsupport.businessobjects.com/KanisaSupportSite/search.do;jsessionid=567DFC4534FB09F9043B26D3A4AD2602?cmd=displayKC&docType=kc&externalId=c2018884&sliceId=&dialogID=11926763&stateId=1%200%2011930614

     

    Essentially, it seems that reports created in Crystal Reports 10 are not always editable in Crystal Reports 11, particularly table linkages etc.  Basic design alterations don't seem to be affected.

     

    If this error is recieved when attempting to add an additional table to a report. Revert back to a copy of the report before the new table was added and make sure smart linking is turned off in crystal reports before attempting to add a new table.  You will need to setup the links to the new table manually using the link tab in Database Expert (under the Database menu).  Smart linking can be turned off by oepning Crystal Reports and selecting File | Options, Select the database tab and uncheck Automatic Smart Linking and click ok.

    Environment

    Crystal Reports 11