Solved

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

Posted on 2010-08-17
1
1,973 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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
get column names from table in vb.net 8 49
SSRS 2013 - Overlapping reports 2 32
average of calculation (TSQL) 4 26
Parse this column 6 25
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Detach & Attach 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.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

808 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