Reg: Blank Pages while Exporting to PDF

  • Hai,

    I'm developing reports in SSRS 2000. In one of my reports, while exporting to PDF there are blank pages coming in the middle of the report pages. I have already adjusted page size and page margin and checked the report. But I couldn't find it useful. Its an urgent requirement for me and any inputs are appreciated.

    Thanks in Advance

    Krishna Chaitanya.

  • Pull the body of the report up close to the table. When a new column is added it expands the body after you size everything for 8x10 you need to pull that body back to the table. Even though you set your margins and page widths in the properties it will still throw a blank page because of that extra body width.

  • You can also change the dimensions to landscape but the 10x8 dimensions still count just the other direction so you have to design the reports and font sizes with the paper dimensions in mind if you want PDFs.

  • I had a similar problem. When I exported my report to PDF or printed from the web I would get an empty page after every real page. I messed the padding, the margins and nothing worked. So I changed the page size on the report properties to 1 inch wider than my report measured on the layout. For example: my report was to print on 8.5 x 11 Landscape. My report measured 10.5 inches wide on the grid ( I set this from the header properties). I went to the report properties and set the Page Size Width to 11.5 inches. Problem fixed! It printed perfectly every time and paged perfectly in my PDF as well.

    I hope this helps someone even though my response is well after the original post.:D

  • Did you do this to ssrs or adobe?

  • If you are using 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.

  • When setting the page size, you need to take into account the margin as well because that need to be added to your page size.

  • i have same problem when i export report into pdf file its print blank page after one line. guys pls give me a solution. i am using sql 2008.

  • Hi, chaitanya.krishna1.

    I know that RAQ Report can help users to set page break for report easily. Moreover, you can export report to PDF with it just by clicking.

    The dialog box for setting page break is shown below:

    RAQ Report: Web-based Excel-like Java reporting tool[/url]

  • I found this on another forum but it is applicable here

    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)

Viewing 10 posts - 1 through 9 (of 9 total)

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