• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2242
  • Last Modified:

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


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
Brave-River
Asked:
Brave-River
1 Solution
 
wolfman007Commented:
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

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now