SSRS page break after row with subreport (in rectangle)

reporting-servicesssrs-2008ssrs-2008-r2ssrs-groupingssrs-tablix

I've spend hours searching for a solution for something 'simple'. I have a report (SSRS 2008 R2) with a tablix with rows grouped on saleslineid. For each salesline I want to show a sub-report with specs and after that the components of the salesline. But I want the list of components to start on a new page.

For instance:

SPECS:

Object A

Color Brown

Height 200

— PAGE BREAK! —

LIST OF COMPONENTS

Item Description

100 COMP1

101 COMP2

etc

As you can see in the picture I've put my subreport in a rectangle and set PageBreak – Breaklocation to End.

SSRS layout

Tried it with an inbetween row with a rectangle too. Read about 100 pages with more or less similar issues but I can't get it to work?

Can this be done?

Kind regards,

Mike

Best Answer

It can be done but to clarify is this your layout? In your subreport should it look like this?

  • Specs
  • Components (this is on another page)

If yes then you enclose the whole specs in a rectangle then define a PageBreak -> BreakLocation on the End
Or
Enclose the whole Components in a rectangle then define a PageBreak -> BreakLocation on the Start

Related Topic