CR2011 - 2 subreports span pages

[AWMeyer]

Hi,
I have a report in CR2011 where I'm trying to allow two sub reports to span pages. What I'm getting is each one taking a new page and not spanning together. Here's what I have:

---
GroupHeader1a

[Subreport 1]
---
GroupHeader1b

[Subreport 2]
---
Details (Supressed)
---
Group Footer1
Various fields
---

Group Header 1a and 1b can only be so large (page is divided into thirds for each printing section). So IF Sub1 is too many rows it rolls over to a new page. It takes the whole page. Then after all of Sub1 has finally printed, Sub2 finally starts its second page and takes the whole page.

What I want is for each new page to be set up exactly like the first. Sub1 over Sub2 over Group Footer and to maintain that format until the end of the group where it will start over with new data. Added info, Sub1 and Sub2 are identical, so if Sub1 spans a page, so will Sub2.

I am printing on perferated stock (in thirds) and need to limit the number of rows in Sub1 and Sub2 and make the left over rows from Sub1 and Sub2 flow to the next page of stock in the same position as page one and never encroach on the space the footer needs.

Hope all that makes sense and any assistance would be great!

Thanks
Adam

 

[IdoMillet]

Right-click the subreport,
Select 'Format Subreport'...
and turn off the 'Keep Object Together' option.

Cheers,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[AWMeyer]

Hi Ido,

I've done that but what I get is Sub1 takes up most of page 1 (because it can grow) and sub2 takes up the rest of the page and part of the next and then my footer prints. What I need is for sub1 and sub2 to be limited to about a 3 inch tall area on each page (one over the other) and flow into those areas until they have used all their rows. I'll try to mock it up below.

---
^ Sub1 Page 1 (rows 01-20)
|
|
3"
|
V
---
^ Sub2 Page 1 (rows 01-20)
|
|
3"
|
V
---
^ Footer Page 1 (left blank)
|
|
3"
|
V
---

Next Page
---
^ Sub1 Page 2 (rows 21-40)
|
|
3"
|
V
---
^ Sub2 Page 2 (rows 21-40)
|
|
3"
|
V
---
^ Footer Page 2 (left blank)
|
|
3"
|
V
---
Next Page
---
^ Sub1 Page 3 (rows 41-45)
|
|
3"
|
V
---
^ Sub2 Page 3 (rows 41-45)
|
|
3"
|
V
---
^ Footer Page 3 (Prints)
|
|
3"
|
V
---

 

[IdoMillet]

Looks like you need to break your subreports to different subreports based on row ranges.

hth,
- Ido

view, export, burst, email, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[AWMeyer]

Hmm, So you are suggesting that sub1 and sub2 be sub1a (1-20) sub2a (1-20) / sub1b (21-40) sub2b (21-40) etc. Correct?
How then would I set each sub on a different page? Set up a section for each and dictate to that section only to print when page number =1 or =2? Am I picturing that correctly?

Thanks
Adam