I'm doing a top 50 report using a single SQL table. The report has 2 subreports.
It takes forever to run and print. Appears to be reprocessing the SQL procedure for each section of the report, hence 150 times.
The 2 subreports are displaying data as a percent of a summarized field in the main report.
Is this the wrong approach? Is there a way to speed things up?
Thanks
It takes forever to run and print. Appears to be reprocessing the SQL procedure for each section of the report, hence 150 times.
The 2 subreports are displaying data as a percent of a summarized field in the main report.
Is this the wrong approach? Is there a way to speed things up?
Thanks