locked
Report showing up in 2nd page even though there is no data SSRS RRS feed

  • Question

  • Question

    HI all,

    I have a report designed in such a way that tablix is in a rectangle object and set the option keep contents together on a single page , if possible. but still i see blank page with image in header and page numbers from footers are showing up in 2nd page with blank body.

    thanks,

    Jo

    Thursday, August 8, 2013 3:00 PM

Answers

  • Check the width of your work area.  If your output is 8.5 x 11 with half-inch margins, then your work area should be 7.5 inches wide.  If it's even one tick wider, SSRS will treat the space off to the side as a separate page, and you will get a blank trailing page.  It's unfortunate, but that's the way SSRS has always worked.

    It's really easy to accidentally enlarge the work area.  So, when you see a blank trailing page, just check the width and tighten it back down.


    • Edited by John Smith 3 Thursday, August 8, 2013 3:41 PM blah
    • Proposed as answer by John Smith 3 Wednesday, August 14, 2013 12:31 PM
    • Marked as answer by Charlie Liao Sunday, August 18, 2013 11:25 AM
    Thursday, August 8, 2013 3:41 PM
  • Hi Jyo1105,

    On your scenario, the report display on two pages even though there is no data, it seems that you preview the report on Print Layout mode. In Reporting Services, the print layout is shown base on physical page. The physical page size is the paper size, and the default page size is 8.5 x 11 inches. If the report body grows past the right edge of the physical page, then a page break is inserted horizontally. If the report body grows past the bottom edge of the physical page, then a page break is inserted vertically. So we can trouble shooting this issue as follow.

    1. Please make sure (Body Width + Left margin + Right margin) <= (Page width).
    2. Even If the width is right, textbox or other report item also could cause the width of the body to exceed the page width. In addition, report items growing horizontally (matrix data regions and images set to automatically Autosize or Fit) can also cause the body to grow. So please also make sure there is no items or textboxes will extend the width due to the content in the items.

    Besides, there is another possible reason and solution for your reference:
    http://www.bidn.com/blogs/DustinRyan/ssis/492/blank-page-at-end-of-ssrs-2008-report
    For more information please see following link:
    http://technet.microsoft.com/en-us/library/dd255278.aspx
    Regards,
    Nicole Yu


    Nicole Yu
    TechNet Community Support


    • Edited by Nicole Yu Friday, August 9, 2013 9:38 AM error
    • Marked as answer by Charlie Liao Sunday, August 18, 2013 11:25 AM
    Friday, August 9, 2013 9:00 AM

All replies

  • Check the width of your work area.  If your output is 8.5 x 11 with half-inch margins, then your work area should be 7.5 inches wide.  If it's even one tick wider, SSRS will treat the space off to the side as a separate page, and you will get a blank trailing page.  It's unfortunate, but that's the way SSRS has always worked.

    It's really easy to accidentally enlarge the work area.  So, when you see a blank trailing page, just check the width and tighten it back down.


    • Edited by John Smith 3 Thursday, August 8, 2013 3:41 PM blah
    • Proposed as answer by John Smith 3 Wednesday, August 14, 2013 12:31 PM
    • Marked as answer by Charlie Liao Sunday, August 18, 2013 11:25 AM
    Thursday, August 8, 2013 3:41 PM
  • Hi Jyo1105,

    On your scenario, the report display on two pages even though there is no data, it seems that you preview the report on Print Layout mode. In Reporting Services, the print layout is shown base on physical page. The physical page size is the paper size, and the default page size is 8.5 x 11 inches. If the report body grows past the right edge of the physical page, then a page break is inserted horizontally. If the report body grows past the bottom edge of the physical page, then a page break is inserted vertically. So we can trouble shooting this issue as follow.

    1. Please make sure (Body Width + Left margin + Right margin) <= (Page width).
    2. Even If the width is right, textbox or other report item also could cause the width of the body to exceed the page width. In addition, report items growing horizontally (matrix data regions and images set to automatically Autosize or Fit) can also cause the body to grow. So please also make sure there is no items or textboxes will extend the width due to the content in the items.

    Besides, there is another possible reason and solution for your reference:
    http://www.bidn.com/blogs/DustinRyan/ssis/492/blank-page-at-end-of-ssrs-2008-report
    For more information please see following link:
    http://technet.microsoft.com/en-us/library/dd255278.aspx
    Regards,
    Nicole Yu


    Nicole Yu
    TechNet Community Support


    • Edited by Nicole Yu Friday, August 9, 2013 9:38 AM error
    • Marked as answer by Charlie Liao Sunday, August 18, 2013 11:25 AM
    Friday, August 9, 2013 9:00 AM