Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / February 2006

Tip: Looking for answers? Try searching our database.

Unwanted pages

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John A - 05 Jan 2006 20:06 GMT
Hi all, I have a report that has a number of sections.  I have put each
section into a list so that a section does not get cut in half between pages.
All is fine except for the fact that when I print the report I get a blank
page (header only) between each page.  I have not set any of the properties
for the list boxes other than the associate dataset and one list has a
grouping.  In other words all the page break check boxes for the lists have
not been checked, which is the default.  Also each list takes up the entire
width of the page, 8.5" and each list starts exactly where the last list
ended.

Any idea why this is happening?

Signature

Thank you,
John

Kaisa M. Lindahl - 05 Jan 2006 20:18 GMT
You need to factor in the margins when you're calculating the page width.
Check if body width + report margin width is not more than the report page
size width. In that case, you'll end up with extra pages.

Kaisa M. Lindahl
> Hi all, I have a report that has a number of sections.  I have put each
> section into a list so that a section does not get cut in half between
[quoted text clipped - 11 lines]
>
> Any idea why this is happening?
John A - 05 Jan 2006 22:47 GMT
Thanks Kaisa,
I set the body width to 8.0 the margins are 0.2, total is 8.4 page is 8.5
and I am still getting the same poor result, extra blank pages.

Signature

Thank you,
John

> You need to factor in the margins when you're calculating the page width.
>  Check if body width + report margin width is not more than the report page
[quoted text clipped - 16 lines]
> >
> > Any idea why this is happening?
John A - 05 Jan 2006 23:16 GMT
Okay, Mia Culpa, I had set the List's to 8.0 not the body.  Now with the List
at 8.0 and the Body at 8.0 no unwanted pages are being displayed.

Signature

Thank you,
John

> Thanks Kaisa,
> I set the body width to 8.0 the margins are 0.2, total is 8.4 page is 8.5
[quoted text clipped - 20 lines]
> > >
> > > Any idea why this is happening?
Inamori - 28 Feb 2006 08:54 GMT
I face the same problem. Could you advise me?

Report property: 21cm, all margin to to 0.5cm
list layout: 18.75cm, 3.75cm
box size: 19.75cm, 4.5cm

could you advise?

> Okay, Mia Culpa, I had set the List's to 8.0 not the body.  Now with the List
> at 8.0 and the Body at 8.0 no unwanted pages are being displayed.
[quoted text clipped - 23 lines]
> > > >
> > > > Any idea why this is happening?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.