Hi everybody.  I have a report problem that I cannot figure out.
I have a subreport in the body section of my report that is causing
some big problems.  The subreport is pulling investment information
and is attached to the account number of the main form.  So every time
the account number changes the subreport shows the correct investment
information.  Everything works fine as long as the account number
stays below 40 records or so.   Once the subreport gets too large it
messes up all of the spacing as it tries to fit as many records as
possible onto the first page of the report.  This ends up giving me a
first page with just the stuff in my header section, a second page
with everything in my detail section, and a blank third page (or a few
records from the subreport, depending on the number of records).
Is there anything that I can do in the properties that will limit the
size of the subreport so it will not get too big for the main report
without changing the Can Grow property?  I do not want to cut data off
I just want it to move to the next page.  I do not want to create two
separate reports, because the report is exported to PDF and emailed
through the database.  I do not want two emails going to the customer
jsut because the PDF cannot make two pages.

My report has an Account Number header section.  In the section I have
just static stuff (logo, disclosure, etc.) as well as headers for a
few columns whose data changes with every customer.  In the body
section I have the fields that correspond to the headers that I
mentioned above and below that I have my subreport.  Neither the
suberport or the main report have any page breaks set up currently.  I
have tried placing page breaks everywhere that I though would help,
but nothing doing.

Thanks in advance for your help!

Erick C wrote:

>Hi everybody.  I have a report problem that I cannot figure out.
>I have a subreport in the body section of my report that is causing
>some big problems.  The subreport is pulling investment information
>and is attached to the account number of the main form.  So every time
>the account number changes the subreport shows the correct investment
>information.  Everything works fine as long as the account number
>stays below 40 records or so.   Once the subreport gets too large it
>messes up all of the spacing as it tries to fit as many records as
>possible onto the first page of the report.  This ends up giving me a
>first page with just the stuff in my header section, a second page
>with everything in my detail section, and a blank third page (or a few
>records from the subreport, depending on the number of records).
>Is there anything that I can do in the properties that will limit the
>size of the subreport so it will not get too big for the main report
>without changing the Can Grow property?  I do not want to cut data off
>I just want it to move to the next page.  I do not want to create two
>separate reports, because the report is exported to PDF and emailed
>through the database.  I do not want two emails going to the customer
>jsut because the PDF cannot make two pages.
>
>My report has an Account Number header section.  In the section I have
>just static stuff (logo, disclosure, etc.) as well as headers for a
>few columns whose data changes with every customer.  In the body
>section I have the fields that correspond to the headers that I
>mentioned above and below that I have my subreport.  Neither the
>suberport or the main report have any page breaks set up currently.  I
>have tried placing page breaks everywhere that I though would help,
>but nothing doing.

I can't tell what sections you have or what you are getting
in the report.  When you are trying to describe a report (or
form), you should use specific terms like detail section,
investment group header/footer, page header/footer, etc.
It's difficult to make out what you have when you just say
header and body.

As a guess, it sounds like you have the investment group's
KeepTogether property set to Whole Group and that is causing
the group header and all the details to be moved to a second
page.  If so, try changing it to With First Detail.

-- 
Marsh
MVP [MS Access]

I apologize for my messy post, trying to do too many things at one
time.  You are correct, I should clarify.
My top of my report is an Account Number Header.  Currently, I have my
logo, legal disclosure notice, date, and a row of labels that sit
above a row of text boxes that is located at the very top of the
detail section, (to give the appearance of two rows of data) in the
header.  The entire header is around an incha and a half.
In the Detail section I have the text boxes that I previously
described.  Below that is customer information (name and address,
etc.), and around 2 inches down in the Detail section I have a
subreport that is providing the security information.
My database cycles through each individual customer and creates a PDF,
so there is never more than one customer's information in the report
when it is turned into a PDF.  In its current state, the report
provides a header on the first page, but if there are more than 48
securities that are displayed by the subreport it creates a second
page for the PDF.  This second page has no headers, as you would
expect given I am using the Account Number header.  If there is a
second page that is created as the report is right now, nothing is
incorrect on page 1, page 2 is only missing a header.
I tried to move the logo, date, and legal part into the Page Header,
trying to get the information on page 2, but when I move the fields
and delete them from the Account Number Header I end up with
Page 1 - Page header and Account Number Header sections only
Page 2 - Page Header and Detail section
Page 3 - Blank page

I am using Access 2003, so I have grp Keep Together on the report and
I have Keep Together on the detail section properties.  In the detail
properties I can only select yes or no.  Even if I change it to no I
still get the results described above.
Am I stuck without headers for any extra pages that my report makes,
or is there a potential workaround that I am just missing somewhere?


On Feb 12, 3:25=A0pm, Marshall Barton <marshbar...@wowway.com> wrote:
> Erick C wrote:
> >Hi everybody. =A0I have a report problem that I cannot figure out.
> >I have a subreport in the body section of my report that is causing
> >some big problems. =A0The subreport is pulling investment information
> >and is attached to the account number of the main form. =A0So every time
> >the account number changes the subreport shows the correct investment
> >information. =A0Everything works fine as long as the account number
> >stays below 40 records or so. =A0 Once the subreport gets too large it
> >messes up all of the spacing as it tries to fit as many records as
> >possible onto the first page of the report. =A0This ends up giving me a
> >first page with just the stuff in my header section, a second page
> >with everything in my detail section, and a blank third page (or a few
> >records from the subreport, depending on the number of records).
> >Is there anything that I can do in the properties that will limit the
> >size of the subreport so it will not get too big for the main report
> >without changing the Can Grow property? =A0I do not want to cut data off
> >I just want it to move to the next page. =A0I do not want to create two
> >separate reports, because the report is exported to PDF and emailed
> >through the database. =A0I do not want two emails going to the customer
> >jsut because the PDF cannot make two pages.
>
> >My report has an Account Number header section. =A0In the section I have
> >just static stuff (logo, disclosure, etc.) as well as headers for a
> >few columns whose data changes with every customer. =A0In the body
> >section I have the fields that correspond to the headers that I
> >mentioned above and below that I have my subreport. =A0Neither the
> >suberport or the main report have any page breaks set up currently. =A0I
> >have tried placing page breaks everywhere that I though would help,
> >but nothing doing.
>
> I can't tell what sections you have or what you are getting
> in the report. =A0When you are trying to describe a report (or
> form), you should use specific terms like detail section,
> investment group header/footer, page header/footer, etc.
> It's difficult to make out what you have when you just say
> header and body.
>
> As a guess, it sounds like you have the investment group's
> KeepTogether property set to Whole Group and that is causing
> the group header and all the details to be moved to a second
> page. =A0If so, try changing it to With First Detail.
>
> --
> Marsh
> MVP [MS Access]- Hide quoted text -
>
> - Show quoted text -

Erick C wrote:

>I apologize for my messy post, trying to do too many things at one
>time.  You are correct, I should clarify.
>My top of my report is an Account Number Header.  Currently, I have my
>logo, legal disclosure notice, date, and a row of labels that sit
>above a row of text boxes that is located at the very top of the
>detail section, (to give the appearance of two rows of data) in the
>header.  The entire header is around an incha and a half.
>In the Detail section I have the text boxes that I previously
>described.  Below that is customer information (name and address,
>etc.), and around 2 inches down in the Detail section I have a
>subreport that is providing the security information.
>My database cycles through each individual customer and creates a PDF,
>so there is never more than one customer's information in the report
>when it is turned into a PDF.  In its current state, the report
>provides a header on the first page, but if there are more than 48
>securities that are displayed by the subreport it creates a second
>page for the PDF.  This second page has no headers, as you would
>expect given I am using the Account Number header.  If there is a
>second page that is created as the report is right now, nothing is
>incorrect on page 1, page 2 is only missing a header.
>I tried to move the logo, date, and legal part into the Page Header,
>trying to get the information on page 2, but when I move the fields
>and delete them from the Account Number Header I end up with
>Page 1 - Page header and Account Number Header sections only
>Page 2 - Page Header and Detail section
>Page 3 - Blank page
>
>I am using Access 2003, so I have grp Keep Together on the report and
>I have Keep Together on the detail section properties.  In the detail
>properties I can only select yes or no.  Even if I change it to no I
>still get the results described above.
>Am I stuck without headers for any extra pages that my report makes,
>or is there a potential workaround that I am just missing somewhere?


The group KeepTogether property is the bottom one in the
Sorting and Grouping window.  A section's KeepTogether
property is only for rhat one section.  If you have the main
report detail section's KeepTogether property set to Yes,
that will also cause the entire section to go to the next
page when it is too big to fit on the same page as the group
header so I think you remove that setting too.

You can make a group header section appear on each page by
setting its RepeatSection property to Yes.

The blank page at the end is usually caused by setting the
detail (or group footer) section's ForceNewPage property to
After Section, or by a page break control at the bottom ot
the section.  You can avoid this if you set the group header
section's ForceNewPage property to Before Section and don't
use the detail (or group footer) property.

-- 
Marsh
MVP [MS Access]

Marsh -
Thank you for your reply.  I went in and made the changes that you
suggested and the report is working perfectly!
Thanks again!



On Feb 12, 5:51=A0pm, Marshall Barton <marshbar...@wowway.com> wrote:
> Erick C wrote:
> >I apologize for my messy post, trying to do too many things at one
> >time. =A0You are correct, I should clarify.
> >My top of my report is an Account Number Header. =A0Currently, I have my
> >logo, legal disclosure notice, date, and a row of labels that sit
> >above a row of text boxes that is located at the very top of the
> >detail section, (to give the appearance of two rows of data) in the
> >header. =A0The entire header is around an incha and a half.
> >In the Detail section I have the text boxes that I previously
> >described. =A0Below that is customer information (name and address,
> >etc.), and around 2 inches down in the Detail section I have a
> >subreport that is providing the security information.
> >My database cycles through each individual customer and creates a PDF,
> >so there is never more than one customer's information in the report
> >when it is turned into a PDF. =A0In its current state, the report
> >provides a header on the first page, but if there are more than 48
> >securities that are displayed by the subreport it creates a second
> >page for the PDF. =A0This second page has no headers, as you would
> >expect given I am using the Account Number header. =A0If there is a
> >second page that is created as the report is right now, nothing is
> >incorrect on page 1, page 2 is only missing a header.
> >I tried to move the logo, date, and legal part into the Page Header,
> >trying to get the information on page 2, but when I move the fields
> >and delete them from the Account Number Header I end up with
> >Page 1 - Page header and Account Number Header sections only
> >Page 2 - Page Header and Detail section
> >Page 3 - Blank page
>
> >I am using Access 2003, so I have grp Keep Together on the report and
> >I have Keep Together on the detail section properties. =A0In the detail
> >properties I can only select yes or no. =A0Even if I change it to no I
> >still get the results described above.
> >Am I stuck without headers for any extra pages that my report makes,
> >or is there a potential workaround that I am just missing somewhere?
>
> The group KeepTogether property is the bottom one in the
> Sorting and Grouping window. =A0A section's KeepTogether
> property is only for rhat one section. =A0If you have the main
> report detail section's KeepTogether property set to Yes,
> that will also cause the entire section to go to the next
> page when it is too big to fit on the same page as the group
> header so I think you remove that setting too.
>
> You can make a group header section appear on each page by
> setting its RepeatSection property to Yes.
>
> The blank page at the end is usually caused by setting the
> detail (or group footer) section's ForceNewPage property to
> After Section, or by a page break control at the bottom ot
> the section. =A0You can avoid this if you set the group header
> section's ForceNewPage property to Before Section and don't
> use the detail (or group footer) property.
>
> --
> Marsh
> MVP [MS Access]- Hide quoted text -
>
> - Show quoted text -