Post reply

Blank pages in print preview and pdf format view

  • September 27, 2005 at 7:45 am

    #165343

    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.

  • September 27, 2005 at 12:05 pm

    #593394

    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

  • September 27, 2005 at 9:10 pm

    #593520

    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.

  • September 28, 2005 at 6:55 am

    #593637

    Check out this blog:

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

     

  • September 28, 2005 at 7:27 am

    #593654

    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.

     

  • January 19, 2007 at 3:57 pm

    #684467

    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.

     

  • May 7, 2009 at 9:11 am

    #990404

    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.

  • September 1, 2009 at 3:11 am

    #1047363

    for me some report come with proper formate and some time its add blank pages

  • September 1, 2009 at 3:42 am

    #1047378

    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[/url].

    Welcome to my blog[/url].:P

  • September 1, 2009 at 8:02 am

    #1047547

    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

  • September 8, 2009 at 6:53 am

    #1050469

    Hi,

    Pls find attached file and let me know changes.

    Thanks.

  • September 18, 2009 at 7:14 am

    #1055570

    Hi,

    To avoid Blank pages in PDF

    In BIDS, do the following:

    1.Click on Report > Report Properties > Layout tab

    2.Make a note of the values for Page width, Left margin, Right margin

    3.Close and go back to the design surface

    4.In the Properties window, select Body

    5.Click the + symbol to expand the Size node

    6.Make a note of the value for Width

    To render in PDF correctly Body Width + Left margin + Right margin must be less than or equal to Page width. When you see blank pages being rendered it is almost always because the body width plus margins is greater than the page width.

    Remember: (Body Width + Left margin + Right margin) <= (Page width)

    Thanks,

    Nemo

  • December 14, 2009 at 9:59 am

    #1092069

    contactatif (5/7/2009)

    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.

    now, my report is working like a charm.

    It helped me a lot.

    many thanks!

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply