Sub-report starts on new page

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

re: Sub-report starts on new page

Check the "Force new Page property of the subreport

"ysh8o1" <yann.shukor@gmail.comwrote in message
news:1163510894.023001.259270@m73g2000cwd.googlegr oups.com...

re: Sub-report starts on new page

Hi and thanks for the response

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

ysh

re: Sub-report starts on new page

ysh8o1 wrote: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

re: Sub-report starts on new page

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" <yann.shukor@gmail.comwrote in message
news:1163522007.863995.120020@h54g2000cwb.googlegr oups.com...

re: Sub-report starts on new page

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

re: Sub-report starts on new page

ysh8o1 a écrit :
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

re: Sub-report starts on new page

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" <yann.shukor@gmail.comwrote in message
news:1164376953.269669.115850@l12g2000cwl.googlegr oups.com...

ysh8o1 a écrit :
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