If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subreport page break in label controls or textbox controls
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 |
#2
|
|||
|
|||
Subreport page break in label controls or textbox controls
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/d...displaylang=en -- 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. "Rob Parker" wrote in message ... 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 |
#3
|
|||
|
|||
Subreport page break in label controls or textbox controls
Thanks for the response Allen.
Unfortunately, it's not A2007 - it's A2003. Any further thoughts? Rob Allen Browne wrote: 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/d...displaylang=en "Rob Parker" wrote in message ... 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 |
#4
|
|||
|
|||
Subreport page break in label controls or textbox controls
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. "Rob Parker" wrote in message ... Thanks for the response Allen. Unfortunately, it's not A2007 - it's A2003. Any further thoughts? Rob Allen Browne wrote: 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/d...displaylang=en "Rob Parker" wrote in message ... 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 |
#5
|
|||
|
|||
Subreport page break in label controls or textbox controls
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 On Aug 26, 11:09*pm, "Allen Browne" wrote: 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. "Rob Parker" wrote in message ... Thanks for the response Allen. Unfortunately, it's not A2007 - it's A2003. *Any further thoughts? Rob snip |
#6
|
|||
|
|||
Subreport page break in label controls or textbox controls
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 Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Rob" wrote in message ... 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 On Aug 26, 11:09 pm, "Allen Browne" wrote: 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. "Rob Parker" wrote in message ... Thanks for the response Allen. Unfortunately, it's not A2007 - it's A2003. Any further thoughts? Rob snip |
#7
|
|||
|
|||
Subreport page break in label controls or textbox controls
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 Browne wrote: 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" wrote in message ... 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 On Aug 26, 11:09 pm, "Allen Browne" wrote: 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. "Rob Parker" wrote in message ... Thanks for the response Allen. Unfortunately, it's not A2007 - it's A2003. Any further thoughts? Rob snip |
Thread Tools | |
Display Modes | |
|
|