CR 8.5, Oracle DB connected via Oracle ODBC
I am in the process of moving to CR 11 but have run into a problem.
I have several 8.5 reports that have "AND NOT EXISTS...." that I added on the Database->Show SQL Query screen.
While the 8.5 reports with the "AND NOT EXITS..." statements migrates and runs fine in CR 11, how can I create the equivalent in CR 11? When I click on Database->Show SQL Query, the page is locked or frozen so I can no longer do this.
I played around with the Add command a bit but not sure how what to place in it and how to link it if required.
The user guide that came with the install is useless as it has nothing about the Add command. The online help is of little use.
Any help would be appreciated.
-lw
I am in the process of moving to CR 11 but have run into a problem.
I have several 8.5 reports that have "AND NOT EXISTS...." that I added on the Database->Show SQL Query screen.
While the 8.5 reports with the "AND NOT EXITS..." statements migrates and runs fine in CR 11, how can I create the equivalent in CR 11? When I click on Database->Show SQL Query, the page is locked or frozen so I can no longer do this.
I played around with the Add command a bit but not sure how what to place in it and how to link it if required.
The user guide that came with the install is useless as it has nothing about the Add command. The online help is of little use.
Any help would be appreciated.
-lw