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!

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

Substitute for "and exists" for CR11

Status
Not open for further replies.

kskid

Technical User
Mar 21, 2003
1,767
US
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
 
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top