Page Breaks in subreport ignored

[TRob]

Access 97 - I have a subreport that needs a page break
after a footer section. I have the page break inserted in
a footer and it runs just fine if I run the subreport by
itself. But when I run the main report that contains the
subreport, the page breaks in the subreport seem to be
ignored.

Is there any way to enforce the page breaks in the
subreport when the main report is run?

Thanks

 

[Marshall Barton]

Access 97 - I have a subreport that needs a page break
after a footer section. I have the page break inserted in
a footer and it runs just fine if I run the subreport by
itself. But when I run the main report that contains the
subreport, the page breaks in the subreport seem to be
ignored.

Is there any way to enforce the page breaks in the
subreport when the main report is run?

Most page related thing are ignored in subreports (Page
Header/Footer, PageBreak controls, etc?), but a few do seem
to be functional within the limits of a subreport control
(ForceNewPage, RepeatSection, etc??).

You may not get quite what you want and it can get kind of
messy, but try removing the PageBreak control and using the
section's ForceNewPage property instead. This will,
necessarily, require that the subreport control and its
section both have their CanGrow property set to Yes.

If you have the page break control in the middle of the
section (instead of at the end), then you will need to add a
level to Sorting and Grouping using a constant expression
such as =1. You can then place the controls before the
page break in one section and the ones after the page break
in another section.

 

[TRob]

Thanks! It worked

-----Original Message-----



Most page related thing are ignored in subreports (Page
Header/Footer, PageBreak controls, etc?), but a few do seem
to be functional within the limits of a subreport control
(ForceNewPage, RepeatSection, etc??).

You may not get quite what you want and it can get kind of
messy, but try removing the PageBreak control and using the
section's ForceNewPage property instead. This will,
necessarily, require that the subreport control and its
section both have their CanGrow property set to Yes.

If you have the page break control in the middle of the
section (instead of at the end), then you will need to add a
level to Sorting and Grouping using a constant expression
such as =1. You can then place the controls before the
page break in one section and the ones after the page break
in another section.

 

[daudihus]

I have a similar problem. I want to limit the number of record
displayed on a subreport (say 30) and calculate subtotals for thos
records. After that I want to force a new page in the main report an
continue to show subtotals in the subreport until all my records on th
subreport are displayed (with a grand total)


-
daudihu