Adding additional table Using OLE DB (ADO)

[Luvsql]

I have a report that has many tables and subreports using an OLE DB connection to another server. I now have the report and am changing the connection to our server. I can now browse data in all the tables fine. HOwever, when I go to add a new table join and refresh the report (or print the report in our .Net application), I receive the following error:

Failed to open a rowset.
Query Engine Error: 'If tables are already linked then the join type cannot change.'

I can browse data from this new table in the report. I am not changing any other table joins, just adding a new one.

 

[Luvsql]

This error is now happening on all my reports that used to work yesterday (ie I can't add any new tables to existing reports).

 

[crogers111]

I am having the same issue and am still searching for a solution. I updated a CR 8.5 report to CR 10. The report has a few subreports and prompts for a parameter (user id) I am using OLE DB connection. After adding any new table and attempting to run the report: 'Failed to return Rowset error'

followed by: 'Query Engine Error: If tables are already linked then join type cannot change'

Anyone have a solution or ideas ?

 

[crogers111]

I believe I have resolved this. I turned off smart linking in the registry and can now add a new table and set my own linking. Here's the steps for CR10 per the Crystal Support Website:

Edit the Windows Registry to Turn Off Smart Linking
----------------------------------------------

1. On the 'Start' menu, click 'Run'.

2. Type "regedit" in the 'Open' combo-box then click 'OK'. This opens the Registry Editor.

3. Browse to the following registry sub key:

HKEY_CURRENT_USER\Software\Crystal Decisions\10.0\Crystal Reports\DatabaseOptions

4. Right-click the 'DoAutoSmartLinking' string value then click 'Modify'.

5. Type 'No' in the 'Value data' text box then click 'OK'. Close the Registry Editor.

You can now create a report with multiple tables without automatically linking them.

 

[Luvsql]

I am running version 9 and this option isn't available in the registry nor in the application. Boo!