Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: SubReport Duplication Post Reply Post New Topic
Author Message
FrnhtGLI
Senior Member
Senior Member
Avatar

Joined: 22 May 2009
Online Status: Offline
Posts: 347
Quote FrnhtGLI Replybullet Topic: SubReport Duplication
    Posted: 27 May 2009 at 11:18am
INTRO:
 
I have a main report with 4 sub reports. The sub reports are stored in separate Report Footers. If the first one prints, the other 3 are suppressed and inversely, if the first is suppressed, the other 3 print. The information contained in the sub reports will vary depending on the size of the information in the XML.
 
PROBLEM:
 
If the sub reports all fit on one page and not too close to the end of the page, then everything looks greatClap. BUT, if the first sub report has to continue on to a secod page, it prints the last three rows of information from the previous page on the top of the second pageAngry. I think my totals still end up correct, but this doesn't look rightDead.
 
Similarly, if the 3 sub reports all fit on one page, but the second and third are really close to the end of the page, they print on the bottom of the first page, then reprint on the top of the next pageConfused.
 
I tried creating a Global NumberVar that initializes on the Report Header and calculates at the report footer, thinking if it started at 0 and was +1 whenever that report footer was processed, then I could conditionally suppress it if the field was ever greater than 1. The problem is, the report footer is only being processed 1 time. At the bottom of the first page, the global numbervar gave me a value of 1 and was also 1 at the top of the second page.
 
HELP!!!!! I'm not sure why it is duplicating information and have tried just about everything.
 
Thanks in advance for any informationWink.
 


Edited by FrnhtGLI - 28 May 2009 at 6:57am
IP IP Logged
FrnhtGLI
Senior Member
Senior Member
Avatar

Joined: 22 May 2009
Online Status: Offline
Posts: 347
Quote FrnhtGLI Replybullet Posted: 28 May 2009 at 7:02am
Okay, so I worked out a solution that should probably only be temporary, but if no one else can think of anything else, or any reason why it is acting this way, then I guess I will just have to keep it as-is.
 
Anyway, I created a Running Total that Initializes a 0 at the Sub Report Header and calculates +1 for the detail lines. I determined that 55 lines on a page looks good and page break after the Running total hits 55, 110, 165 and so on. If I page break the information does not duplicate on the next pageClap.
 
Sooo...This works and all, but I still would like to know why it was duplicating the information on the next pages.
 
Anyone?
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.047 seconds.