Substitute for "and exists" for CR11

[kskid]

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

 

[synapsevampire]

Rather than modify existing SQL, in CR 9 and above you have the option of aan Add Command which allows you to paster the entire SQL statement in.

You can then create parameters and apply them to the SQL statement within the Query creation Add Command screen.

Bit of a paradigm shift, but overall you should appreciate the advantages.

Of course there are some downsides as well.

You would be better served to create Stored Procedures or Views on the database to handle this and stop embedding SQL into the client end.

-k

 

[kskid]

Sigh.... OK Just when I thought I was getting pretty proficient and comfortable with CR 8.5.

I am trying to teach myself with not only CR 11 but BO XI Enterprise, as well and now add Stored procedures to that.

Ah well. Such is life for a Crystal user. Never a dull moment, that's for sure.

-lw