Subreport page break in label controls or textbox controls

  • Thread starter Thread starter Rob Parker
  • Start date Start date
R

Rob Parker

I have a report with a series of subreports in separate group footers
(all grouping on InspID). One of these subreports is behaving
strangely, as follows: If the subreport starts near the bottom of the
page, then either some label controls in the subreport's Report Header
section, or a record in the subreport's Detail section, will be split
by the Page Footer of the main report.

The Group Footer and the subreport control in the Group Footer both
have Can Grow/Can Shrink both set to "Yes".

The Keep Together property of the Group Footer is "With First
Detail". Changing this to either "No" or "Whole Group" has no effect
on the problem.

The subreport's Report Header has Keep Together set to "Yes".
Changing this to "No" has no effect on the problem. [Note: this
Report Header section has a large label control at the top, and a row
of smaller label controls (column headings for the detail section)
below that. The subreport can break within either the large label or
the row of label controls.]

The subreport is sorted by DamageID, has no Group Header or Group
Footer, and the Detail section has the Keep Together property in the
Sorting/Grouping dialog for DamageID set to "With First Detail".
Changing this to either "No" or "Whole Group" has no effect on the
problem.

The subreport's Detail section has its Keep Together property set to
"Yes", and both Can Grow/Can Shrink set to "Yes". The textbox
controls (three, all the same height, in a single row) in the Detail
section also have Can Grow/Can Shrink set to "Yes".

What am I missing here, to solve this problem?

TIA,

Rob
 
Thanks for the response Allen.

Unfortunately, it's not A2007 - it's A2003. Any further thoughts?

Rob


Allen said:
Is this Access 2007? If so, see if the symptoms in this hotfix
describe what you are seeing:
http://support.microsoft.com/kb/970233/

Service Pack 2 for Office 2007 was released after that hotfix, so if
you have not yet done so, you probably want to download SP2 and apply
it first. Source:
http://www.microsoft.com/downloads/...18-79ea-46c6-8a81-9db49b4ab6e5&displaylang=en


Rob Parker said:
I have a report with a series of subreports in separate group footers
(all grouping on InspID). One of these subreports is behaving
strangely, as follows: If the subreport starts near the bottom of the
page, then either some label controls in the subreport's Report
Header section, or a record in the subreport's Detail section, will
be split by the Page Footer of the main report.

The Group Footer and the subreport control in the Group Footer both
have Can Grow/Can Shrink both set to "Yes".

The Keep Together property of the Group Footer is "With First
Detail". Changing this to either "No" or "Whole Group" has no effect
on the problem.

The subreport's Report Header has Keep Together set to "Yes".
Changing this to "No" has no effect on the problem. [Note: this
Report Header section has a large label control at the top, and a row
of smaller label controls (column headings for the detail section)
below that. The subreport can break within either the large label or
the row of label controls.]

The subreport is sorted by DamageID, has no Group Header or Group
Footer, and the Detail section has the Keep Together property in the
Sorting/Grouping dialog for DamageID set to "With First Detail".
Changing this to either "No" or "Whole Group" has no effect on the
problem.

The subreport's Detail section has its Keep Together property set to
"Yes", and both Can Grow/Can Shrink set to "Yes". The textbox
controls (three, all the same height, in a single row) in the Detail
section also have Can Grow/Can Shrink set to "Yes".

What am I missing here, to solve this problem?

TIA,

Rob
Click to expand...
Click to expand...
 
If this is Access 2003 SP1, it would be worth applying at least SP2.

If you have SP2 or SP3, the first culprit to check out would be the printer
driver. Since Access uses the metrics from the printer driver to calculate
the layout of reports, a buggy printer driver can give screwed-up reports.
To test this idea, try installing a completely different kind of printer
driver (e.g. dot matrix if you're using a laser), and see if the report
previews correctly there. If it does, you know the solution will be to
install a newer (or perhaps an older) driver for your printer.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.


Rob Parker said:
Thanks for the response Allen.

Unfortunately, it's not A2007 - it's A2003. Any further thoughts?

Rob


Allen said:
Is this Access 2007? If so, see if the symptoms in this hotfix
describe what you are seeing:
http://support.microsoft.com/kb/970233/

Service Pack 2 for Office 2007 was released after that hotfix, so if
you have not yet done so, you probably want to download SP2 and apply
it first. Source:
http://www.microsoft.com/downloads/...18-79ea-46c6-8a81-9db49b4ab6e5&displaylang=en


Rob Parker said:
I have a report with a series of subreports in separate group footers
(all grouping on InspID). One of these subreports is behaving
strangely, as follows: If the subreport starts near the bottom of the
page, then either some label controls in the subreport's Report
Header section, or a record in the subreport's Detail section, will
be split by the Page Footer of the main report.

The Group Footer and the subreport control in the Group Footer both
have Can Grow/Can Shrink both set to "Yes".

The Keep Together property of the Group Footer is "With First
Detail". Changing this to either "No" or "Whole Group" has no effect
on the problem.

The subreport's Report Header has Keep Together set to "Yes".
Changing this to "No" has no effect on the problem. [Note: this
Report Header section has a large label control at the top, and a row
of smaller label controls (column headings for the detail section)
below that. The subreport can break within either the large label or
the row of label controls.]

The subreport is sorted by DamageID, has no Group Header or Group
Footer, and the Detail section has the Keep Together property in the
Sorting/Grouping dialog for DamageID set to "With First Detail".
Changing this to either "No" or "Whole Group" has no effect on the
problem.

The subreport's Detail section has its Keep Together property set to
"Yes", and both Can Grow/Can Shrink set to "Yes". The textbox
controls (three, all the same height, in a single row) in the Detail
section also have Can Grow/Can Shrink set to "Yes".

What am I missing here, to solve this problem?

TIA,

Rob
Click to expand...
Click to expand...
Click to expand...
 
Hi again Allen,

I'm using Access 2003 SP2. [Can't find SP3 on the Microsoft site to
apply that - and subsequent hotfix(es) to fix its problems.]

I've tried changing the default printer (report is set to use default
printer) to several different printers and problem remains the same
for all of them. Printers include (old) HP LaserJet 1200 Series PCL,
Microsoft Office Document Image Writer, HP5100, and Xerox C2428. What
next?

Rob


If this is Access 2003 SP1, it would be worth applying at least SP2.

If you have SP2 or SP3, the first culprit to check out would be the printer
driver. Since Access uses the metrics from the printer driver to calculate
the layout of reports, a buggy printer driver can give screwed-up reports..
To test this idea, try installing a completely different kind of printer
driver (e.g. dot matrix if you're using a laser), and see if the report
previews correctly there. If it does, you know the solution will be to
install a newer (or perhaps an older) driver for your printer.
Click to expand...
<snip>
 
Not sure what else to suggest.

Presumably you have already checked that you have not chosen margins so
small that it encroaches on the unprintable area of the printer.

Sounds like you have already tried different settings for the properties of
the report sections too. It is possible to give Access an impossible set of
conditions (e.g. keep all these things together when they are actually too
big to fit on the page), but I don't see that you are doing that.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.


Rob said:
Hi again Allen,

I'm using Access 2003 SP2. [Can't find SP3 on the Microsoft site to
apply that - and subsequent hotfix(es) to fix its problems.]

I've tried changing the default printer (report is set to use default
printer) to several different printers and problem remains the same
for all of them. Printers include (old) HP LaserJet 1200 Series PCL,
Microsoft Office Document Image Writer, HP5100, and Xerox C2428. What
next?

Rob


If this is Access 2003 SP1, it would be worth applying at least SP2.

If you have SP2 or SP3, the first culprit to check out would be the
printer
driver. Since Access uses the metrics from the printer driver to
calculate
the layout of reports, a buggy printer driver can give screwed-up
reports.
To test this idea, try installing a completely different kind of printer
driver (e.g. dot matrix if you're using a laser), and see if the report
previews correctly there. If it does, you know the solution will be to
install a newer (or perhaps an older) driver for your printer.
Click to expand...
<snip>
Click to expand...
 
Thanks for listening.

I'll check those things further next time I'm at the site for that database
(next Monday). I doubt that they're the problem, since this
report/subreports has been working fine for a couple of years. The thing
that caused it to show up was that several of the other subreports in the
main report (I mentioned in my original post that there were a number of
subreports - the problem one is in the 3rd group footer) contained no data
in the case where the problem occurred, and so the problem subreport in this
case is appearing at a different place than would normally be the case. My
intellect tells me that this should be irrelevant, but it's all I can
isolate as different now.

Rob



Allen said:
Not sure what else to suggest.

Presumably you have already checked that you have not chosen margins
so small that it encroaches on the unprintable area of the printer.

Sounds like you have already tried different settings for the
properties of the report sections too. It is possible to give Access
an impossible set of conditions (e.g. keep all these things together
when they are actually too big to fit on the page), but I don't see
that you are doing that.

Rob said:
Hi again Allen,

I'm using Access 2003 SP2. [Can't find SP3 on the Microsoft site to
apply that - and subsequent hotfix(es) to fix its problems.]

I've tried changing the default printer (report is set to use default
printer) to several different printers and problem remains the same
for all of them. Printers include (old) HP LaserJet 1200 Series PCL,
Microsoft Office Document Image Writer, HP5100, and Xerox C2428. What
next?

Rob


If this is Access 2003 SP1, it would be worth applying at least SP2.

If you have SP2 or SP3, the first culprit to check out would be the
printer
driver. Since Access uses the metrics from the printer driver to
calculate
the layout of reports, a buggy printer driver can give screwed-up
reports.
To test this idea, try installing a completely different kind of
printer driver (e.g. dot matrix if you're using a laser), and see
if the report previews correctly there. If it does, you know the
solution will be to install a newer (or perhaps an older) driver
for your printer. --
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

message
Thanks for the response Allen.

Unfortunately, it's not A2007 - it's A2003. Any further thoughts?

Rob
Click to expand...
<snip>
Click to expand...
Click to expand...
 
Back
Top