getting error

[sql99]

Hello everyone,

I saved a crystal report from version 8 to version 9 and upon trying to execute it(run it), I get the following messages - 'The database file "abc" has changed. Proceeding to fix up report!'. I click OK for all of them and get a message saying that the database is up to date. However after that, I get an error message that says, 'Failed to open a rowset. Details: 42S22:[Oracle][ODBC][Ora]ORA-00904: invalid column name. After I click OK, nothing happens.

If I go and Database -> Show SQL Query and hit the "reset" button, the report will run but the data doesn't seem to be correct. Can someone please tell me what's wrong with my report?

Thanks,
sql99

 

[synapsevampire]

Perhaps there's something understood as a reserved word involved or some such.

Please post technical information:

Oracle database version
Connectivity type
What is in the Database->Show SQL Query

My first guess would be that you're using the wrong type of connectivity, such as the Oracle supplied ODBC driver, switch to Oracle native connectivity or the Crystal supplied ODBC driver. Earlier versions might have been mre forgiving of this common oversight, but you shouldn't use the Oracle supplied ODBC driver.

-k