Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
radhikavarshit
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 ordersPlease let me know how to break a page in Report Viewer when we run a report directly.Thanks in AdvanceRadhikaRadhikaSenior Software Engineer |
|
|
visakh16
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 MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
Page Breaks between sub-reports in the same group