Solved

SQL Server 2008 Reporting Services - Page breaks not working in sub reports

Posted on 2010-08-17
1
1,994 Views
Last Modified: 2012-06-27

In SQL Server Reporting Services 2008, I am creating a report to pull in a sub-report.  I am bringing this sub-report into a table as a detail row in my main report.  The sub-report is also being used as an independent report and has page breaks defined at a table group level.  When I view this report as a sub-report, the page breaks are being ignored.  Is there any way to make the page breaks work when the report is viewed as a sub-report?

 
0
Comment
Question by:Brave-River
1 Comment
 
LVL 14

Accepted Solution

by:
wolfman007 earned 500 total points
ID: 33485872
Explicit page breaks are ignored within sub reports.

This is because page breaks are not supported on items that can be hidden, as it can radically alter the layout of a page.

Have a look at the following websites

http://blogs.msdn.com/b/bwelcker/archive/2005/08/19/alien-lanes-_2800_logical-and-physical-pagination-rules_2900_.aspx

http://www.developmentnow.com/g/115_2004_7_0_0_449392/No-Page-Break-within-SubReport.htm

You could try putting a rectangle around the subreport and setting that to cause page break.

See the following website for an example of how to use a rectangle to handle the pagination of the subreport.

http://blog.datainspirations.com/2010/04/13/ssrs-page-number/
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Count with a subquery showing details 10 57
get column names from table in vb.net 8 69
MS SQL + Insert Into Table - If Doesnt Exist 9 57
Can I skip a node in XML? 9 30
Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

713 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