Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Blank pages in print preview and pdf format view Expand / Collapse
Author
Message
Posted Tuesday, September 27, 2005 7:45 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, March 18, 2013 9:01 AM
Points: 59, Visits: 40
Hi,
I have developed some reports and when I export it pdf format or look at print preview, I can see some blank pages added to the report. Here are the scenarios :
1) there is a report of 1 page only, but when I see print preview it says 2 pages and second page is empty.
2) I had a 2 page report, with 2 tables side by side. now the result from one of the columns in second table is bit long and this results in 2 page report. When I print preview or export to pdf this report, the first page has data followed by empty page followed by some data and finally followed by empty page again. I dont know why this is happening.

Any suggestions are welcome.
Post #223897
Posted Tuesday, September 27, 2005 12:05 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, December 11, 2013 12:00 PM
Points: 57, Visits: 88
Hi,

1.) Check the report to make sure it is with in the boundaries of the page size. (To get the Report properties click on the left corner at the top of the report designer, when you have done it correctly a black square appears - go to the other side of the screen and click the properties panel.) Page Size property should be 8.5in, 11in or 11in, 8.5in. Make sure also that the report will fit into either those two sizes. If the report is bigger then the page size you will get most of first page of your report on one page and the rest on the second.
2.) Make sure the margins are correct. If you report size is 8in across and your margins are set at 2 in left and right then it will print the first page an two different pages. (That will make your report actually 12 in across so, set you margins at .2in or something that is mathematically correct.)
3.) Also, if the left right margins are not helping with the issue, change the top and bottom margins to .5in or even less, which will sometimes help.
4.) CanGrow property for the textboxes is sometimes the culprit but I can not confirm or deny that.

I hope that helps. I had to write up something for work sor that problem.
Thanks, Kerrie
Post #224052
Posted Tuesday, September 27, 2005 9:10 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Monday, July 28, 2014 8:56 AM
Points: 1,815, Visits: 3,455

If you've got tables with hidden sections (visibility toggle?) You might want to ensure that you're running SP2 for Reporting Services, apparently it fixed a similar issue.  Below is from the readme...

4.2.4 Tables with Details Sections

New in SP2. A table with a hidden or removed details section displays correct page breaks when rendered as an image or PDF file. Previously, a table with a hidden or removed details section would insert page breaks in unexpected locations.




Steve.
Post #224211
Posted Wednesday, September 28, 2005 6:55 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 17, 2014 8:42 AM
Points: 112, Visits: 195

Check out this blog:

http://blogs.msdn.com/bwelcker/archive/2005/08/19/454043.aspx

 

Post #224348
Posted Wednesday, September 28, 2005 7:27 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, March 18, 2013 9:01 AM
Points: 59, Visits: 40

Thank you everyone for the replies. I have set the margins as 0 and it worked for me. I tried by making margins very small 0.25 but still didnt work.

Thanks again.

 

Post #224367
Posted Friday, January 19, 2007 3:57 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 19, 2007 3:52 PM
Points: 1, Visits: 1

Here is another solution. 

For example, if the size of your report in development layout is 13 inches wide including margins but you hide columns so that the run-time size of the report is under 11 inches with margins included, in the Report Properties you can set the PageSize width to 13 inches and the Interactive Size width property to 11 inches.  With either property you need to make sure that the report width size plus your margins are less than or equal to the width value.

 

Post #338376
Posted Thursday, May 7, 2009 9:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 7, 2014 8:27 AM
Points: 5, Visits: 93
Guys in SSRS 2008,

Very important property that can be easily ignored here is: ConsumeContainerWhitespace property of the Report. This is set to False by default, So the whitespace is not ignored by the renderer and is repeated on next page. Setting this to True solved all my Extra Blank Page problems in SSRS 2008.

Cheers.
Post #712102
Posted Tuesday, September 1, 2009 3:11 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, June 2, 2014 7:13 AM
Points: 45, Visits: 151
for me some report come with proper formate and some time its add blank pages
Post #780515
Posted Tuesday, September 1, 2009 3:42 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 4, 2009 5:07 AM
Points: 5, Visits: 66
I'm using RAQ Report. It's a free excel-like java reporting tool. RAQ Report can export report to Word, Excel, Pdf easily. You can have a try. You can get free RAQ Report at http://www.raqsoft.com.

Welcome to my blog.:P
Post #780535
Posted Tuesday, September 1, 2009 8:02 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, December 11, 2013 12:00 PM
Points: 57, Visits: 88
What SSRS are you using, if there is any SP? Are you allowed to send me the rdl? There has to be something that is hidden, going beyond the margins, or the page property is not correct. I would need more information about what it is doing when you try to print.

Thanks,
Kerrie
Post #780728
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse