Managing subreports in a form footer

  • Thread starter Thread starter WSF
  • Start date Start date
W

WSF

Access 97
I have a report detailing activity which varies in length (down the page)
depending of volume of data.
The main report contains Groups with Headers.
Each Group is sub-totaled and the Main Report Grand Totals are in the Report
Footer.
Also in the Report Footer are two sub-reports.

My problem is the varying length of the Main Report and the Sub-reports.
Sometimes all will fit onto the one page.
But when the volume of data requires it, the length of the Main Report in
Detail will shunt the sub reports onto the next page. That's okay, except
that it also breaks the page in the middle of the second sub-report. Is
there a way I can ensure that the sub-reports are not broken across a page
break?

I have tried different permutations of the settings in design view without
success.
Any assistance gratefully appreciated.

WSF
 
Hello Marsh,
Sorry, I didn't really explain well enough.
The problem is that the Main Reports Grand Totals are on the Report Footer
too.
I don't want them on the next page.

Picture a report where the main reports takes, say, half to two thirds of
the first page.
The first sub reports is always the same size and takes about half the
remainder.
The second sub-report can vary in length (on the page) depending on the data
range.
Sometimes it will fit on the page with the others, other times it will run
over onto the next page - that is, part of that second sub-report will be on
the first page and the rest on the second page.
I would like it to move entirely to the second page if there is going to be
an overrun in terms of length.
Alternatively, both sub-reports could default to the second page, but what
then of the main grand totals?

Hope that's clear.

I am unsure about my Grand Totals though - they cannot be on the page footer
obviously and can only be on the report footer - right?

Regards,
WSF
 
WSF said:
Access 97
I have a report detailing activity which varies in length (down the page)
depending of volume of data.
The main report contains Groups with Headers.
Each Group is sub-totaled and the Main Report Grand Totals are in the Report
Footer.
Also in the Report Footer are two sub-reports.

My problem is the varying length of the Main Report and the Sub-reports.
Sometimes all will fit onto the one page.
But when the volume of data requires it, the length of the Main Report in
Detail will shunt the sub reports onto the next page. That's okay, except
that it also breaks the page in the middle of the second sub-report. Is
there a way I can ensure that the sub-reports are not broken across a page
break?

I have tried different permutations of the settings in design view without
success.
Click to expand...


Setting the report footer section's KeepTogether property
should take care of this.
 
WSF said:
Sorry, I didn't really explain well enough.
The problem is that the Main Reports Grand Totals are on the Report Footer
too.
I don't want them on the next page.

Picture a report where the main reports takes, say, half to two thirds of
the first page.
The first sub reports is always the same size and takes about half the
remainder.
The second sub-report can vary in length (on the page) depending on the data
range.
Sometimes it will fit on the page with the others, other times it will run
over onto the next page - that is, part of that second sub-report will be on
the first page and the rest on the second page.
I would like it to move entirely to the second page if there is going to be
an overrun in terms of length.
Alternatively, both sub-reports could default to the second page, but what
then of the main grand totals?

Hope that's clear.

I am unsure about my Grand Totals though - they cannot be on the page footer
obviously and can only be on the report footer - right?
Click to expand...


In other words, you want to use KeepTogether on just a part
of the report footer, right?

To do that, you need to put the parts you want to keep
together in their own section. This can be done by creating
additional top level groups based on a constant expression
such as =1. Add footer sections for these groups and move
the parts to their own footer. Then you can use the
KeepTogether property as needed. The only drawback to this
approach is that in a multi-column report, group footers are
confined to a single column.
 
Back
Top