Print Page | Close Window

multiple subreports

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=17107
Printed Date: 06 May 2024 at 4:48am


Topic: multiple subreports
Posted By: z9962
Subject: multiple subreports
Date Posted: 25 Jul 2012 at 4:51am
Hello, I am creating a large report (600+ pages)
for each page I will have 1 of 6 sub reports displaying depending on the group.
 
I though Crystal would not run a subreport if it is suppressed?
 
If I have one subreport that runs for all 600 pages it takes 8 minutes,
as soon as a add the second subreport suppressing either one depending on the page, it takes 17 minutes. and again with the third it takes 26 minutes.
 
The number of pages does not change in the main part of the report (600)
Then why does the time double when I add an addtional subreport when I am suppressing the other?
 
Thanks for your help...


Replies:
Posted By: DBlank
Date Posted: 26 Jul 2012 at 4:13am

sub reports that are suppressed do not run (with a few caveats)

You may be doing other calculations or adding in new fields into the report for the new subreport. Or perhaps your new subreport is including another field from a new table wich is now enforcing a join and causing your data set to expand.
You may want to test things out by adding in the processes without the subreport and just suppressing or showing text objects. and see how long it takes to run.
another issue is that the second sub report may be taking much longer to run than the first one.


Print Page | Close Window