none
Page breaks in tablix inside subreport

    Question

  • I know this question has been asked many times, but I'm not finding a good resolution.

    I am working in SSRS 2008R2. My report contains 3 subreports, each with their own header. Individually, the subreports perform as expected and appear good.

    However, once they are included in the main report, the page breaks are ignored and the data for all groups displayed in one mass of data. This is totally unacceptable for obvious reasons. Fortunately, two fo the subreports have no page break needs, but the details display 18 pages instead of one for each Batch.

    since the report is routinely run multiple times each day and for multiple grops (40-50 per run) this creates a logistical nightmare.

    Reading previous posts on this subject (which mostly referred to 2008 and the fact that 2005 allowed such behaviour) I've seen the standard repsonse "this is by design".

    I cannot think of a situation where this would be true. I cannot bring the subreport into the main report as it screws up the headers. With a varying number of pages within each subreport there is no way to determine the active page (PageName) hasn't worked for this purpose) for dynamic header information and dynamic images. To be able to properly handle the dynamic header info issue, the decision was made to use subreports.

    Has anyone found a way around this problem? This hould have been simple, and in 2005 it would have ben easy.

    I am open to suggestions, as long as it's not the suggestion that this is a design feature.

    Thanks!

    Gary

    Friday, March 22, 2013 10:11 PM

Answers

  • Fanny,

    I finally embedded the tablix (with a header built into the outer group) into the report without using a subreport.

    Now the pages break properly within the tablix, but the pagebreak between the first page (Invoice) and the details page is sporadic. The first 2 Batches appear correctly, but the next few have the Invoice and details on the same page with no break.

     What is making it extremely hard to track down is th fact that after a few inaccurate pages, I get more correct pages. I've looked for a pattern, but so far no success.

    Do you have any idea what might cause this?

    Thanks!

    • Marked as answer by GaryT_Musicman Wednesday, April 10, 2013 8:09 PM
    Wednesday, March 27, 2013 10:37 PM

All replies

  • First calculate the size of subreport(in pdf).

    Ex. Page Height - Upper and lower margins - Header and footer in main report - any other component that is displayed ont the same page along with subreport.

    Then make sure that difference in start position of two tablixes is same as that of the amount calculated above.

    Saturday, March 23, 2013 5:00 AM
  • I have calculated the page size several times, allowing for margins, headers, footers, etc. The subreport has plenty of wiggle-room on the report and is not the issue.

    The issue appears to be the "Keep together" aspect of subreports. Is there a way to override that?

    Monday, March 25, 2013 2:00 PM
  • Hello,

    If I understand correctly, the subreport display the detail information about the main report. Can the data of subreport be filter by a field in the main report? If so, you can redesign the main report by add a group on this field and specify page break. In the subreport, create a parameter to filter subreport data and then pass filed values from main report to subreport parameter when add subreport in main report.
    For more information,please see: Add a Subreport and Parameters

    If I have any misunderstanding, Could you please post both the report and the dataset with sample data to us by the following E-mail address?  It is benefit for us to do further analysis.
    E-mail: sqltnsp@microsoft.com

    Regards,
    Fanny Liu


    Fanny Liu
    TechNet Community Support

    Wednesday, March 27, 2013 7:23 AM
    Moderator
  • Fanny,

    I finally embedded the tablix (with a header built into the outer group) into the report without using a subreport.

    Now the pages break properly within the tablix, but the pagebreak between the first page (Invoice) and the details page is sporadic. The first 2 Batches appear correctly, but the next few have the Invoice and details on the same page with no break.

     What is making it extremely hard to track down is th fact that after a few inaccurate pages, I get more correct pages. I've looked for a pattern, but so far no success.

    Do you have any idea what might cause this?

    Thanks!

    • Marked as answer by GaryT_Musicman Wednesday, April 10, 2013 8:09 PM
    Wednesday, March 27, 2013 10:37 PM