Sub Report forces new page

  • Thread starter Thread starter Dave Gottholm
  • Start date Start date
D

Dave Gottholm

I have a report with an associated sub report on its
detail section. The two reports are linked via the child
and master link fields (which involves two fields).

The report works correctly but the problem that I am
having is that whenever the link fields change, it forces
a new page which makes the report a lot longer then it has
to be. I do not want this to happen since I only want a
page break based on another field of the master record.

I cannot find the property to keep it from doing this. I
do not have the force new page property set on either the
main report or on the detail of the subreport.

Does anyone know how I can keep from having new pages when
the linked fields change?

Thanks,

Dave
 
Hi Dave,

Have you tried tinkering with the Can Grow/Can Shrink properties, and the
margins on both the subReport and the main Report?

Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Content-Class: urn:content-classes:message
| From: "Dave Gottholm" <[email protected]>
| Sender: "Dave Gottholm" <[email protected]>
| Subject: Sub Report forces new page
| Date: Thu, 29 Apr 2004 12:49:38 -0700
| Lines: 20
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQuIxrN88lo7YXhTx+ZDXtyIs+rDQ==
| Newsgroups: microsoft.public.access.reports
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.reports:137053
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.access.reports
|
| I have a report with an associated sub report on its
| detail section. The two reports are linked via the child
| and master link fields (which involves two fields).
|
| The report works correctly but the problem that I am
| having is that whenever the link fields change, it forces
| a new page which makes the report a lot longer then it has
| to be. I do not want this to happen since I only want a
| page break based on another field of the master record.
|
| I cannot find the property to keep it from doing this. I
| do not have the force new page property set on either the
| main report or on the detail of the subreport.
|
| Does anyone know how I can keep from having new pages when
| the linked fields change?
|
| Thanks,
|
| Dave
|
 
Back
Top