[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2006-05-18
Medium Priority
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
  • 3
LVL 14

Accepted Solution

simon_kirk earned 2000 total points
ID: 16717483
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

ID: 16717498
I'll check those now.

Author Comment

ID: 16717553

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

ID: 16806708

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

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

872 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