Limit Subreport Records - Repost

[Michael]

Hi Folks - I have report/subreport situation. The main report lists teacher
information and the subreport lists the classes they teach. On the first
page of the report, I want the subreport to list only 3 classes. On the
second page of the report (I added a page break), I want to display the rest
of the classes. So, if a teacher has 10 classes, the first 3 classes would
be on the first page and classes 4-10 would be on the second page.

So far, I have placed a subreport on page one and a subreport on page two. I
know I can modify the top values parameter for the first page subreport to
limit the classes to 3, but I'm stuck with displaying classes 4-10 on the
second subreport. Any ideas?

Thanks,

Michael

 

[steveh]

I don't think I've ever tried to force a page break in a subreport, but
if this doesn't work in the subreport, how about putting the teacher
information in the subreport and have the classes in the main report? Of
course, the subreport can still be at the beginning.

This is just a sketchy outline. Ask for more details if needed.

Create a text box, not visible, with a running sum to keep count of the
record displayed. Add a page break to the same section and make it
visible dependent on whether your "counter" text box is equal to 4 or
not. So, in the group header's or detail's format section, you would
have something like

Me!HiddenPageBreak = Me!ClassCounter = 4.

It should work.

Steve