Solved

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

Posted on 2010-08-17
1
1,881 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
Comment Utility
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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
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…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

772 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

10 Experts available now in Live!

Get 1:1 Help Now