"Rowset Error" option

[Parkaboy]

While upgrading from CR 8.5 to 9x I ran into a "rowset" error message when trying to access the Oracle DB on only on a few reports ( out of many) At a total loss for the reason why, I did the following:

Clicked on the "database" pulldown menu,
Selected "Show SQL Query" and clicked the "reset" button

The last command in the SQL query was eliminated , clicked OK and refreshed the report with no errors! (the selection criteria that was deleted from the SQL query exists in the selection formula)

Quick and simple solution. Hope this is helpful to others as it saved me a TON of frustration........

 

[synapsevampire]

It may be that someone had manually edited the SQL.

In which case these reports are probably now incorrect.

-k