I am working on a challenging report in Crystal 10. The purpose of the report is to show a main record, it's information and associated child records. Each page is designed to be a snapshot of the main record and one of the child records, including graphics. There will be multiple main records and there can be any number of child records, ranging from 0 to hundred.
I have the report grouped by main record and then child record. Because of the nature of the records, this report has several subreports. The design of the report contains several subreports relating to the main record in the group1 header, a band of child record information in the group2 area and then more main record subreports in the group1 footer. Due to the amount of other data on the page, the number of records on my subreports cannot grow any further than I have them scaled. For instance, one subreport displays 4 records, another might show 10 records, etc.
The challenge is overflow from the subreports. I am tasked with providing as much of the data from the main record as I can on the first page (first child record). The second page (second child record) should show the next set of main record information, etc. For instance:
Page 1
GH1`Sales Info Records #1 - #5 (2009, 2008, 2007, 2006, 2005)
GH2 Child record #1
GF1 Purchases Records #1 - #10 (2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 1999)
Page 2
GH1 Next set of Sales Info Records #6 - #10 (2004, 2003, 2002, 2001, 2000)
GH2 Child Record #2
GF1 Next Set of Purchases Records #11 - #20 (1998, 1997, etc,,,)
This is to repeat until the report runs out of subreport records or child records (with a final "can grow" page of the rest of the subreports (purchases and sales).
I have searched and have only found information on check stubs, but this situation is a little more complicated especially with multiple records and pages. I am not sure how many duplicate copies of teh subreports I would have to create to accomodate the amount of records on each subreport. My report would take forever to run. Although one copy of each would be fine if necessary.
Can anyone think of some solution or path for me to follow?