Page Breaks in subreport ignored

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

TRob wrote:

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.

--
Marsh
MVP [MS Access]

Thanks! It worked

-----Original Message-----
TRob wrote:

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.

--
Marsh
MVP [MS Access]
.

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



--
daudihus
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message895030.html