Solved

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

Posted on 2010-08-17
1
2,024 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
PolyServe for SQL server 13 52
Add a step to a system backup job 6 55
Need return values from a stored procedure 8 64
the way to learn Microsoft BI 13 71
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
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…

710 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