|
|
You're in the
sql server reporting services
group:How Do I Get Rid of Blank Pages in Reports?
sql server reporting services:
page header is printed on all the blank pages. I haven't specified any page breaks anywhere.
[quoted text, click to view]
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
[quoted text, click to view]
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 [quoted text, click to view] "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) >
[quoted text, click to view]
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 [quoted text, click to view] > > "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. [quoted text, click to view] "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) > >
[quoted text, click to view]
>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... [quoted text, click to view] >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) >> >> >>
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |