Skip to Content
Former Member
Sep 02, 2008 at 08:53 PM

Report takes longer to print when suppressing rows


I have a report with a parameter that allows the user to choose if they want a detail view or a summary view. The summary view suppresses the details section. If this option is chosen, the report takes much longer to run. (10 minutes vs 80 minutes). Why does this occur? What can be done about it?

I am running CR 11 on a SQL 2005 database. The report returns about 800,000 records. There are around 100 formuals, most of which use global variables, and 3 grouping levels.

The detail version of the report comes in at about 270 pages, the summary version is 12 pages.

Let me know if you need any other details.