locked
Blank Page in PDF Export - SSRS RRS feed

  • Question

  • Hi All,

    I have the multiple pages with in the report. For Example,

    1. Dashboard Page
    2. Risk Summary Page
    3. Issues Summary Page
    4. Key Summary Page
     
    I am using the rectangle for the physical page break and set the page break option as "Add a page break after" for each rectangle except for the last key summary page in the RDL
     
    Other Report details
    Report Paper Size is A4, Landscape, Width = 29.7cm, Height = 21cm
    Report Margins - Left=0.2cm, Right=0.2cm, Top=0.25cm, Bottom=0.25cm
     
    Rectangle size in the report body in each page as
    Width=28.7cm, Height=17.5cm,

    Header Height= 2cm
    Footer Height = 1cm
     
    Now, the issue is when I add the Tablix with the rectangle to display the details data, it also adds the blank page after the page and when I remove the Tablix and only keep the graphs within the rectangle then blank page issue get fixed.
     
    Has anyone come across this issue or can advise the solution options to fix the blank page issue.
     
    Thanks for your help in advance.


    Badal Ratra MCTS





    • Edited by Badal Ratra Wednesday, July 1, 2015 12:57 AM
    Tuesday, June 30, 2015 8:56 AM

Answers

  • Hi Badal,

    According to your description, when you add a tablix and graphs in a rectangle then export to PDF, a blank page will display. But when you only embed graphs in the rectangle, there is no blank page display in PDF report, right?

    In Reporting Services, regarding the blank page in PDF render, we generally check if layout of items in the body meet this requirement: Maximum Body Width=Page Width – (Left Margin + Right Margin). In your scenario, it seems you haven’t checked report body size, so please check it and make sure these items are set correctly to meet the requirement in your report. For more information, please refer to these two articles below:

    The Case of the Extra Page: Rendering Reporting Services as PDF
    Blank Page Issues – SSRS Reports

    Besides, you have mentioned the issue occurs when embed the tablix in the rectangle, so please check if you have added page break before or after the tablix. It would be better if could double check page break option for all report items like rectangle and graphs.

    In SSRS 2008 or higher, there is a Report Property ConsumeContainerWhitespace which controls whether white space in containers should be consumed when contents grow instead of preserving the minimum white space between the contents and the container. The value is set to False by default. So in your scenario, if you are sure there is no extra blank space in your report, please set value of ConsumeContainerWhightspace to True. For more information, please refer to this article: Blank Page at End of SSRS 2008 Report.

    If you have any question, please feel free to ask.

    Best regards,
    Qiuyun Yu


    Qiuyun Yu
    TechNet Community Support



    Wednesday, July 1, 2015 1:56 AM

All replies

  • Hi Badal,

    According to your description, when you add a tablix and graphs in a rectangle then export to PDF, a blank page will display. But when you only embed graphs in the rectangle, there is no blank page display in PDF report, right?

    In Reporting Services, regarding the blank page in PDF render, we generally check if layout of items in the body meet this requirement: Maximum Body Width=Page Width – (Left Margin + Right Margin). In your scenario, it seems you haven’t checked report body size, so please check it and make sure these items are set correctly to meet the requirement in your report. For more information, please refer to these two articles below:

    The Case of the Extra Page: Rendering Reporting Services as PDF
    Blank Page Issues – SSRS Reports

    Besides, you have mentioned the issue occurs when embed the tablix in the rectangle, so please check if you have added page break before or after the tablix. It would be better if could double check page break option for all report items like rectangle and graphs.

    In SSRS 2008 or higher, there is a Report Property ConsumeContainerWhitespace which controls whether white space in containers should be consumed when contents grow instead of preserving the minimum white space between the contents and the container. The value is set to False by default. So in your scenario, if you are sure there is no extra blank space in your report, please set value of ConsumeContainerWhightspace to True. For more information, please refer to this article: Blank Page at End of SSRS 2008 Report.

    If you have any question, please feel free to ask.

    Best regards,
    Qiuyun Yu


    Qiuyun Yu
    TechNet Community Support



    Wednesday, July 1, 2015 1:56 AM
  • Thanks Qiuyun Yu.

    Report Property "ConsumeContainerWhitespace" did work.


    Badal Ratra MCTS

    Wednesday, July 1, 2015 9:19 AM