Page breaks in nested sub reports not working

Question

All:

We have a fairly complicated report with a parent report and three levels of subreports.  For brevity, lets call them Client (main report), Region (sub report level 1), and Division (subreport level 2). 

 

The Client report consists of static text and subreports, including the Region report.

The Region report consists of static text and subreports, including the Division report.

The Division report consists of static text and subreports, none of which have their own subreports.

 

The design calls for page breaks after each subreport.

Page breaks on the Client report works fine.

Page breaks on the Region report work if each subreport is in its own tablix.

Page breaks on the Division will not work. 

 

I’ve put them in their own tablix and rectangles.  I’ve played with KeepTogether settings.  I’ve placed empty rectangles and tablixs between the reports.  Nada.

I’ve read that the subreport control will implicitly try to KeepTogether the report.  What I haven’t read is what method, if any, will allow me to bypass this behavior.

I've read a lot of similar posts, but they were older and did not have a resolution for this.  Any help or a link to a similar problem with an answer would be greatly appreciated.

Thanks,
-Melody

Answer 1

Hi Melody,

As you can see from the http://support.microsoft.com/kb/938943 article, the Subreport control has an implicit KeepTogether property by design. This behavior exists in the current release.

I would recommend you submit the good suggestion to Microsoft Connect at https://connect.microsoft.com/SQLServer/Feedback. Your feedback is valuable for us to improve our products and increase the level of service provided.

Thanks for your understanding.

Regards,
Mike Yin