By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,250 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Sub-report starts on new page

P: n/a
Hi

I have a report containing two sub-reports in the details section.

The first of these contains a list of records, and appears as a
full width blank rectangle, thick enough to contain at least one
record. Auto grow is also active.

However when there are more records than a page can contain,
rather than print an initial portion on current page, the subreport
systematically begins on the following page.

The second sub-report is smaller in size and when required co-
rrectly divides itself between the end of current and beginning of
the following page.
Any ideas ?

Thanks

ysh

Nov 14 '06 #1
Share this Question
Share on Google+
7 Replies


P: n/a
Check the "Force new Page property of the subreport

"ysh8o1" <ya*********@gmail.comwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...
Hi

I have a report containing two sub-reports in the details section.

The first of these contains a list of records, and appears as a
full width blank rectangle, thick enough to contain at least one
record. Auto grow is also active.

However when there are more records than a page can contain,
rather than print an initial portion on current page, the subreport
systematically begins on the following page.

The second sub-report is smaller in size and when required co-
rrectly divides itself between the end of current and beginning of
the following page.
Any ideas ?

Thanks

ysh

Nov 14 '06 #2

P: n/a
Hi and thanks for the response

Unfortunately this property is switched off for all sections in the
sub-report

ysh

Nov 14 '06 #3

P: n/a
ysh8o1 wrote:
Hi and thanks for the response

Unfortunately this property is switched off for all sections in the
sub-report

ysh
If "keep together" is set to yes and the subreport is too big to fit on a
single page then it will break to a new page first even though the new page
won't be able to hold the whole thing either.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
Nov 14 '06 #4

P: n/a
I think there are only three things that can cause a subreport to move to a
new page.
1. The property has to be set to require it - but you checked that.
2. There is some code in an event of the subform (like i"ntGetVal =
Reports![Sales By
Year].Section(acDetail).ForceNewPage")
or
3. there is a pagebreak inserted on the form.

"ysh8o1" <ya*********@gmail.comwrote in message
news:11**********************@h54g2000cwb.googlegr oups.com...
Hi and thanks for the response

Unfortunately this property is switched off for all sections in the
sub-report

ysh

Nov 14 '06 #5

P: n/a
Thanks for the responses.

I agree with those three possibilities.

And having rechecked everything I decided to create a new report and
sub-report objects
copying over only the fields from original versions.

Unfortunately, I get the same result.
Stumped am I !

I guess I'll have to toy around with the layout(s) until I get a
satisfactory result.

Cheers

ysh

Nov 15 '06 #6

P: n/a

ysh8o1 a écrit :
Hi

I have a report containing two sub-reports in the details section.

The first of these contains a list of records, and appears as a
full width blank rectangle, thick enough to contain at least one
record. Auto grow is also active.

However when there are more records than a page can contain,
rather than print an initial portion on current page, the subreport
systematically begins on the following page.

The second sub-report is smaller in size and when required co-
rrectly divides itself between the end of current and beginning of
the following page.
Any ideas ?

Thanks

ysh
Right, I beginning to think that my data is off !

If I place my report's header fields in a page header, the subreport
(which requires more than a page to print) is correctly printed. If
however I place the header fields in a section header, then the same
subreport begins on the next page.

The first option is fine, except that the fields in the page header
section don't get updated in sync with the data in the details section
(i.e. subreport data) but are 'one record' behind

The second option insures that the header info is correct,
unfortunately the data is printed one page behind !

Sorry if all this seems confusing to you - you should see the mess in
my head right now !

Rgds

ysh

Nov 24 '06 #7

P: n/a
Check the "KeepTogether" setting for your subreport.
If set to true it will start at the top of a page regardless of whether
or not it can fit in a page.
"ysh8o1" <ya*********@gmail.comwrote in message
news:11**********************@l12g2000cwl.googlegr oups.com...

ysh8o1 a écrit :
Hi

I have a report containing two sub-reports in the details section.

The first of these contains a list of records, and appears as a
full width blank rectangle, thick enough to contain at least one
record. Auto grow is also active.

However when there are more records than a page can contain,
rather than print an initial portion on current page, the subreport
systematically begins on the following page.

The second sub-report is smaller in size and when required co-
rrectly divides itself between the end of current and beginning of
the following page.
Any ideas ?

Thanks

ysh
Right, I beginning to think that my data is off !

If I place my report's header fields in a page header, the subreport
(which requires more than a page to print) is correctly printed. If
however I place the header fields in a section header, then the same
subreport begins on the next page.

The first option is fine, except that the fields in the page header
section don't get updated in sync with the data in the details section
(i.e. subreport data) but are 'one record' behind

The second option insures that the header info is correct,
unfortunately the data is printed one page behind !

Sorry if all this seems confusing to you - you should see the mess in
my head right now !

Rgds

ysh
Nov 27 '06 #8

This discussion thread is closed

Replies have been disabled for this discussion.