Filed to open a rowset & Unknown Query Engine Error?

[rajrev]

Hi,
We updated from the version CR 8.5 to Ver 9.0.
I got the following error when I ran the report (which was worked prefect in CR 8.5):

1. Filed to open a rowset.
2. Unkown Query Engine Error.

I checked the Verify database too. I says database upto date.

Note: Report contains 2 different databases (SQL & DB2) and also has sub reports.

Please let me know if you have any thoughts/suggesions.

Thanks,
MK

 

[synapsevampire]

Open each subreport and do a Database->Verify database

Combining databases is also a dicey thing, one solutionI use often is to create ODBC sources for each database, then LINK (not import) them into an MS Access database, build out the query in Access, and then use the query in Crystal.

-k

 

[rajrev]

Thanks for your quick response. I will try!

Thanks,
MK