I have a report with a bound subreport on it (LinkMaster & ChildFields both
set). The subreport's page footer doesn't print.
Both main report & sub report are bound to basically the same query,with
additional filtering of the main report. Any ideas how to force the page
footer to print please Phil

On 2012-02-01 10:56 AM, Phil wrote:

Phil,


Only pageheaders and -footers from the outer report are ever used,
pageheaders and -footers in subreports are always ignored. This also
applies to some other attributes, such as page size and orientation.

If you want subtotals inside your subreports you should use Grouping
level headers/footers. These will be shown in the subreports immediately
before/after the section details (but not necessarily at the top/bottom
of the page). However, the fact that the main- and the subreport both
use the same query would suggest that you do not actually need the
subreport at all. Using the correct Grouping levels and corresponding
Headers and Footers a single report should be quite sufficient.


HTH


Jan T

On 01/02/2012 17:59:16, Jan T wrote:
Thank Jan for coming back.
It appears that this posting thread has gone all over the place, so I shall
repost the bits I can’t find. I want to print 4 identical A6 size reports on
1 sheet of A4 paper. The sub reports are normally a calendar for a month, but
the user can choose the date range (FromDate to ToDate), which may make the
calendar longer or shorter. The A4 sheet gets laminated, cut into 4 A6 size
pieces and sits on the dining table in the Club to remind members of
forthcoming events. So they need to be small (A6) and the easiest way to
print them is 4 up on A4 paper.

At the moment I have 4 copies of a sub reports based on a filtered query that
sits on the A4 sheet OK. The problem comes when the data in the sub report is
too long to fit on half the A4 page. If this happens, I need to print a
second main report with the four "overflow sub reports" on it.
The e main report is bound to A query with fields that give Year & Month and
the Sub reports have LinkMasterFields & LinkChild fields set to Year & Month.
The subreports and detail section of the main report is set to
CanShrink & CanGrow to No.

Have adopted your suggestion of putting a label in a group footer instead of
the page footer, and that works fine. If the subreport’t length is less than
6” (half an A4 or a6 length whichever way you want to look at it), then again
all works perfectly. What is happening if the sub report should be sat 1 ½ A6
pages long is that only one page is printing 4 times. Somehow, I need to
print a second page of the main report and have the 4 other ½ pages of the
sub report print on it.

Thanks again

Phil

Phil,

As you have encountered multiple problems with printing 4 up on an A4 sheet,
perhaps you should not say

but "I originally thought the easiest way . . ." then since you've given
good information about the intended use, ask "can you suggest how is the
best way for me to print these using Access?"

You also might bear in mind that the majority of the users of this newsgroup
are in the US and would have to look up the size of A4 and A6, which they
may not feel is warranted to respond to one question.

Clearly, the way you'd like subreports to work is not the way they actually
do work, and no one's posted a useful workaround, so perhaps you might
consider looking at what you could do with printing each of the subreports
on a separate 'main' report, utilizing columns. It might be that would give
you "4 up" most of the time, unless some subreport is "too long" in which
case, you may not waste a great deal of paper and laminate material.

--
Larry Linson
Microsoft Office Access MVP
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010

"Phil" <phil (AT) stantonfamily (DOT) co.uk> wrote

On 01/02/2012 22:29:42, "Access Developer" wrote:
Fair comment Larry

A4 paper is 11.7" long and 8.3" wide
A6 paper is 1/4 that size i.e. 5.8" by 4.1" wide
So o suppose the calendar is 8" long. I want to print 4 identical blocks 5.8"
long by 4.1" wide on the first page (maximum size that will print) and 4
identical blocks 2.2" long by 4.1" wide on the second page.

Phil