Converting v8.5 report to v10

[cisco999]

I have a report that works fine in v8.5 using a odbc connection to oracle. The database verifies ok.
When attempting to preview it under v10, the first message returned is "failed to open rowset", followed by "Query Engine Error:'If tables are already linked then the join type cannot change.'"

Any suggestions on how to resolve this?

Thanks

 

[synapsevampire]

I've heard several complaints about CR 8.5 going to CR 9 and 10 and the joins changing.

I guess I would try using the Set Location to Oracle Native connectivity in CR 8.5 first, not sure why you'd use ODBC anyway, it's slower.

Were you using the Oracle supplied ODBC or the CR supplied ODBC? You're supposed to use the CR supplied ODBC for Oracle in CR 8.5

-k