HELP!!!! Report can't use parameter in SQL Query

[Nunina]

Hi!

We are developing a report which shows all the information of our customers in the form of a contract. We created the report using the wizard, and the Visual Linking Expert. Then added the fields to the report and a parameter to search the data by the customer id.

The SQL Query that Crystal came up with took almost 2:40 minutes to execute when tested in TOAD. We optimized the query to run in 10 secs and pasted it in the SQL Query section of the report.

Now our parameter don't work, and if we want to see any data at all, we have to hard code it in the SQL Query ("AND Table."Cust_ID" = 123456&quot. Otherwise, it show the parameter window, accepts the parameter and then hangs the report!

We are using Crystal Reports ver 8.0, connecting via ODBC to an Oracle database.

Any help will be greatly appreciated. And once again, thanks in advance!!!

Nunina

 

[AmunRa]

It might be worth creating a stored procedure within your oracle database to execute the SQL and then connect your report to that.