Reporting Services...Getting mysterious page breaks at places that make no sense

Posted on 2006-05-18
Last Modified: 2008-01-09

Hi experts. I wasn't sure where I needed to put this question, but I resolved to put it here since it utilizes MS SQL Server.

I have created a master report and several other reports for the purposes of being included as sub-reports. The real issue here is that in the individual reports (the sub-reports), as well as the master report, extra pages are being inserted. For the life of me, I can't figure out where these page breaks are being generated. The sub-reports each have 1 extra page; however, when I put them in the master report it seems like that extra page doesn't carry over, though, the master report does have extra pages. I say that the sub-reports extra pages aren't begin carried over because the data remains together; that is, I have a sub-report at the top of a page of the master report and data half-way down on the actual master report and both appear on the same page with an extra page following the first page of the master report.

I have checked my tables and various other elements to ensure that they are not set to insert page breaks either before or after them, but I find nothing that explains the extra pages that crop up despite this.

Does any one have any pointers on this issue?

Thanks, in advance!
Question by:jbaisden
    LVL 14

    Accepted Solution

    Check your page sizes for the sub and master report, in particular the page width setting for the report and the body sections.

    Author Comment

    I'll check those now.

    Author Comment


    I doubled checked the widths on all of the reports. The sub-reports no longer produce extra pages when viewed by themselves. The master report still does. All page widths are 8.5in and heights are 11in. Margins in all reports are set to .25in. I have set the width and height of each sub-report graphical representation to the same height and width as their respective report. The extra pages are still appearing.

    Author Comment


    The page sizes and margins were what was causing those issues. Thanks simon!

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now