Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Page Breaks between sub-reports in the same group

Author  Topic 

Starting Member

1 Post

Posted - 2013-05-29 : 10:22:00
I have to create a report with sub - reports in the same group.
Let's say we have two tables: Account (ACCPrimaryID, Account Name); WkOrders ( WorkOrder, ACCPrimaryID, Worker, DateIssue etc.)
I have to show Account - 1 details on the first page (Say Account Name and No. of WkOrders) and then work order details on the second page (Say if there are two work orders for Account - 1; they have to be shown on Page 2).
Similarly Account - 2 details on the 3rd page and then work order details for Account - 2 on 4th page.
I tried putting two different sub - reports , but unfortunately the 2nd page details are also appending on the 1st page. But when I do export to PDF, everything works fine. But I need to break the page after I show Account details and then work order details.
This would look more like a Cover Sheet Page (Showing Account Details with No. Of Wkorders), then the details of the work orders
Please let me know how to break a page in Report Viewer when we run a report directly.
Thanks in Advance

Senior Software Engineer

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-29 : 11:32:32
have you put the detail report in a separate container or group? if yes, you could apply property insert page break to make it appear in a new page.

SQL Server MVP
Go to Top of Page

- Advertisement -