Subreport messing up spacing of report

  • Thread starter Thread starter Erick C
  • Start date Start date
E

Erick C

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 said:
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.
Click to expand...

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.
 
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?


Erick said:
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.
Click to expand...
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.
Click to expand...

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]- Hide quoted text -

- Show quoted text -
Click to expand...
 
Erick said:
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?
Click to expand...


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 -
Thank you for your reply. I went in and made the changes that you
suggested and the report is working perfectly!
Thanks again!



Erick said:
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
Click to expand...
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?
Click to expand...

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]- Hide quoted text -

- Show quoted text -
Click to expand...
 
Back
Top