How Do I Get Rid of Blank Pages in Reports?

Every report I've done puts a blank page in between each report page. The
page header is printed on all the blank pages.
I haven't specified any page breaks anywhere.
Is there a way to get rid of the blank pages?On Apr 20, 4:34 pm, Liz <L...@.discussions.microsoft.com> wrote:
> Every report I've done puts a blank page in between each report page. The
> page header is printed on all the blank pages.
> I haven't specified any page breaks anywhere.
> Is there a way to get rid of the blank pages?
One way to alleviate this, in some cases, would be to enclose your
controls (i.e., tables/matrices/textboxes, etc) in a list or rectangle
control and make sure that 'Fit table on one page if possible' is
selected for the table/matrix controls (where applicable). Hope this
is helpful.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Apr 21, 7:34 am, Liz <L...@.discussions.microsoft.com> wrote:
> Every report I've done puts a blank page in between each report page. The
> page header is printed on all the blank pages.
> I haven't specified any page breaks anywhere.
> Is there a way to get rid of the blank pages?
The most likely cause for this is either:
* your report items stretch too wide (beyond the page dimensions) and
are causing extra pages to be printed
* but more likely; the dimensions for your report are not the same as
your printing paper dimensions. Always check the width of your report
body + margins is about equal to the size of your printing paper (e.g.
for A4, your report body should be around 19.5cm wide, and left and
right margins 0.75cm each)|||Well, I'm afraid none of this works.
I put my table in a rectangle and specified to fit on one page when
possible. My report size is not larger than the page size. Nothing is
running off the sides or bottom. The whole report prints; I just get an
extra page between each report page.
I've messed with all of my margins making them bigger then smaller but that
doesn't make any difference either.
If you have any other ideas, I'm all ears. This is going to be a huge waste
of paper.
Thanks,
Liz
"Tokes" wrote:
> On Apr 21, 7:34 am, Liz <L...@.discussions.microsoft.com> wrote:
> > Every report I've done puts a blank page in between each report page. The
> > page header is printed on all the blank pages.
> >
> > I haven't specified any page breaks anywhere.
> >
> > Is there a way to get rid of the blank pages?
> The most likely cause for this is either:
> * your report items stretch too wide (beyond the page dimensions) and
> are causing extra pages to be printed
> * but more likely; the dimensions for your report are not the same as
> your printing paper dimensions. Always check the width of your report
> body + margins is about equal to the size of your printing paper (e.g.
> for A4, your report body should be around 19.5cm wide, and left and
> right margins 0.75cm each)
>|||On Apr 23, 11:56 pm, Liz <L...@.discussions.microsoft.com> wrote:
> Well, I'm afraid none of this works.
> I put my table in a rectangle and specified to fit on one page when
> possible. My report size is not larger than the page size. Nothing is
> running off the sides or bottom. The whole report prints; I just get an
> extra page between each report page.
> I've messed with all of my margins making them bigger then smaller but that
> doesn't make any difference either.
> If you have any other ideas, I'm all ears. This is going to be a huge waste
> of paper.
> Thanks,
> Liz
I'm fairly sure its to do with the size of your report body being
bigger than the paper size (width or height); try setting the report
body size to the absolute minimum it needs to be (i.e. the EXACT size
of the table in the design view) and see if that makes a difference
> "Tokes" wrote:
> > On Apr 21, 7:34 am, Liz <L...@.discussions.microsoft.com> wrote:
> > > Every report I've done puts a blank page in between each report page. The
> > > page header is printed on all the blank pages.
> > > I haven't specified any page breaks anywhere.
> > > Is there a way to get rid of the blank pages?
> > The most likely cause for this is either:
> > * your report items stretch too wide (beyond the page dimensions) and
> > are causing extra pages to be printed
> > * but more likely; the dimensions for your report are not the same as
> > your printing paper dimensions. Always check the width of your report
> > body + margins is about equal to the size of your printing paper (e.g.
> > for A4, your report body should be around 19.5cm wide, and left and
> > right margins 0.75cm each)|||I did all of the above; nothing worked. My entire report width was 10 inches
for a landscape report.
Finally, changing all my margins to zero fixed the problem.
"Tokes" wrote:
> On Apr 23, 11:56 pm, Liz <L...@.discussions.microsoft.com> wrote:
> > Well, I'm afraid none of this works.
> >
> > I put my table in a rectangle and specified to fit on one page when
> > possible. My report size is not larger than the page size. Nothing is
> > running off the sides or bottom. The whole report prints; I just get an
> > extra page between each report page.
> >
> > I've messed with all of my margins making them bigger then smaller but that
> > doesn't make any difference either.
> >
> > If you have any other ideas, I'm all ears. This is going to be a huge waste
> > of paper.
> >
> > Thanks,
> > Liz
> I'm fairly sure its to do with the size of your report body being
> bigger than the paper size (width or height); try setting the report
> body size to the absolute minimum it needs to be (i.e. the EXACT size
> of the table in the design view) and see if that makes a difference
> >
> > "Tokes" wrote:
> > > On Apr 21, 7:34 am, Liz <L...@.discussions.microsoft.com> wrote:
> > > > Every report I've done puts a blank page in between each report page. The
> > > > page header is printed on all the blank pages.
> >
> > > > I haven't specified any page breaks anywhere.
> >
> > > > Is there a way to get rid of the blank pages?
> >
> > > The most likely cause for this is either:
> > > * your report items stretch too wide (beyond the page dimensions) and
> > > are causing extra pages to be printed
> > > * but more likely; the dimensions for your report are not the same as
> > > your printing paper dimensions. Always check the width of your report
> > > body + margins is about equal to the size of your printing paper (e.g.
> > > for A4, your report body should be around 19.5cm wide, and left and
> > > right margins 0.75cm each)
>
>|||>I did all of the above; nothing worked. My entire report width was 10
>inches
> for a landscape report.
> Finally, changing all my margins to zero fixed the problem.
You had a 10 inch width (not sure of height) and you had margins. OK. What
is your printer's printable page area?
IOW: I'm pretty sure you were given correct advice here. Your height +
your top and bottom margin were > your printer's printable page height..
versus actual paper page height...
>L<
"Liz" <Liz@.discussions.microsoft.com> wrote in message
news:F1707B09-ABE5-4CB8-BE2E-FA8436DE5FA6@.microsoft.com...
>I did all of the above; nothing worked. My entire report width was 10
>inches
> for a landscape report.
> Finally, changing all my margins to zero fixed the problem.
> "Tokes" wrote:
>> On Apr 23, 11:56 pm, Liz <L...@.discussions.microsoft.com> wrote:
>> > Well, I'm afraid none of this works.
>> >
>> > I put my table in a rectangle and specified to fit on one page when
>> > possible. My report size is not larger than the page size. Nothing is
>> > running off the sides or bottom. The whole report prints; I just get
>> > an
>> > extra page between each report page.
>> >
>> > I've messed with all of my margins making them bigger then smaller but
>> > that
>> > doesn't make any difference either.
>> >
>> > If you have any other ideas, I'm all ears. This is going to be a huge
>> > waste
>> > of paper.
>> >
>> > Thanks,
>> > Liz
>> I'm fairly sure its to do with the size of your report body being
>> bigger than the paper size (width or height); try setting the report
>> body size to the absolute minimum it needs to be (i.e. the EXACT size
>> of the table in the design view) and see if that makes a difference
>> >
>> > "Tokes" wrote:
>> > > On Apr 21, 7:34 am, Liz <L...@.discussions.microsoft.com> wrote:
>> > > > Every report I've done puts a blank page in between each report
>> > > > page. The
>> > > > page header is printed on all the blank pages.
>> >
>> > > > I haven't specified any page breaks anywhere.
>> >
>> > > > Is there a way to get rid of the blank pages?
>> >
>> > > The most likely cause for this is either:
>> > > * your report items stretch too wide (beyond the page dimensions) and
>> > > are causing extra pages to be printed
>> > > * but more likely; the dimensions for your report are not the same as
>> > > your printing paper dimensions. Always check the width of your report
>> > > body + margins is about equal to the size of your printing paper
>> > > (e.g.
>> > > for A4, your report body should be around 19.5cm wide, and left and
>> > > right margins 0.75cm each)
>>