Using crystal 8.5 - sub reports problem

[rchatterjee]

Hello All

I am using a very old version of Crystal Reports v 8.5. I have a main report and 3 sub reports. All of these reports perform various types of groupings via a call to 3 separate SQL Server 2000 Stored Procedures. The data being queried is rather large and when the SPs are executed thru query analyzer, it takes about 2 minutes each to execute

My problem is when I am executing this query thru Crystal it takes about 5 minutes to bring the results to screen.

Also if I toggle to the subsequent page where the sub queries are there, it takes a very long time to bring up the data (much longer than if I were to run them in Query analyzer)

Can anyone advise how I can optimize my report

 

[synapsevampire]

You state "Also if I toggle to the subsequent page where the sub queries are there", but there aren't subqueries, there are subreports, and within there are stored procedures, which fire each time the subreport is called.

Where are the subreports in the main report?

In general it's best to avoid subreports, perhaps it's not possible in your case, but you need to post basic technnical information.

Also if you place the Page N of M on the first page the report will run to completiong PRIOR to displaying the first page and subsequent pages should pop quickly.

-k

 

[rchatterjee]

Thanks for the reply. I apologize for the lack of info

The main report has a SP with it and 3 sub reports each of which fire a SP. All reports perform separate groupings in the SP.

The subreports have been added to the report footer b section of the main report.