As per my Knowledge, if we are using PL/SQL or Stored Procedures to create Crystal report,

It will filter the data at backend and fetch only the required results to the crystal reports and Stored Procedures are pre-executed queries so that it will fetch the required results to the designer.

For example if you creating a report on SQL database it will fetch all the records to the Crystal and then it will apply the conditions to show the required output.
if we have millions of records in data base it will fetch all the data then it will apply conditions so it will take more time to execute the report.
if we apply condition at database level or if we are using SP then it will send the required data to the designer. In this case report will excecute faster.

HTH

 

--Praveen G

 

I have used an Oracle Package to provide data for a report.  For this particular report there was complex SQL that had different filters based on which of the 7  optional parameters had values.  Accounting for all of the options in a single command made the report slow - 2 to 15 minutes.  After I created the package, which runs different queries based on which parameters have values, it comes back on 15-30 seconds.  So, in this case, there was a tremendous performance increase when passing all of the processing off to the database.

 

-Dell