Crystal Reports 6.0 Error Code 997

Can anyone describe "Crystal Repo开发者_开发技巧rt Engine Returns Error Code 997" for Crystal Reports 6.0? Googling proved futile.

Are you using a long datatype in the data source?

If your theory is right, and if you have the long datatype in either a CONNECT BY, GROUP BY, or ORDER BY clause, that could be the culprit. From what I have read, the ORA-00997 error is as follows:

ORA-00997: illegal use of LONG datatype:

Cause: A value of datatype LONG was used in a function or in a DISTINCT, WHERE, CONNECT BY, GROUP BY, or ORDER BY clause. A LONG value can only be used in a SELECT clause.

I have seen Crystal Reports bubble up unhandled SQL Server errors before, so it's possible.