Skip to Content
0
Former Member
Jun 27, 2008 at 09:17 PM

Crystal Report - Stored procedure

63 Views

I wrote a SQl query that includes a function package. I also, filter the data for a specific date. The query runs in TOAD in about 3 minutes. But in crystal in runs for about 6 hours.

In crystal I used the Parameter Fields option to create a date parameter.

Question: Would creating a Stored Procedure for Startdate, Enddate speed up the processing time?

If the stored procedure is the answer, how do I write it for crystal to read it along with the query?

I appreciate all assistance. Thanks.