Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: multiple subreports Post Reply Post New Topic
Author Message
z9962
Senior Member
Senior Member
Avatar

Joined: 04 Jul 2012
Online Status: Offline
Posts: 161
Quote z9962 Replybullet Topic: multiple subreports
    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...
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.