Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"Rowset Error" option

Status
Not open for further replies.
Parkaboy

Parkaboy

MIS
Dec 2, 2002
22
US
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........:)
 
It may be that someone had manually edited the SQL.

In which case these reports are probably now incorrect.

-k
 
Status
Not open for further replies.

Similar threads

blueboyz
  • Locked
  • Question
Error: The specified module could not be found
Replies
0
Views
80
blueboyz
blueboyz
Soladmin
  • Locked
  • Question
Crystal XI query error"This application has requested the runtime to terminate it in an unusual
Replies
1
Views
75
hilfy
hilfy
IslandLass
  • Locked
  • Question
Is there an equivalent of "Select minus" in Crystal 9 ?
Replies
7
Views
76
IslandLass
IslandLass
brk1221
  • Locked
  • Question
Failed to open a rowset - Crystal Reports - Informix ODBC
Replies
1
Views
29
kray4660
kray4660
abhi900
  • Locked
  • Question
Connection to OLAP universe "Logon Failed"
Replies
0
Views
42
abhi900
abhi900

Part and Inventory Search

Sponsor

Back
Top