3

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

Community
  • 1
  • 1
Mike Dole
  • 675
  • 2
  • 14
  • 30

3 Answers3

0

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

Raymund
  • 7,684
  • 5
  • 45
  • 78
  • Thank you Raymund! Components are in the main report, specs are in the subreport subQuoteSpecs2 which is already in a rectangle with Pagebreak set to breaklocation --> End Regards, Mike – Mike Dole Jan 04 '15 at 21:03
  • is the rectangle in the subreport or in the main report? also have tried putting the rectangle on the components instead? – Raymund Jan 04 '15 at 22:26
  • 1
    Hi Raymund, as shown in the picture subreport is in RectQuoteSpecs2 (on the main report). rectangle on the components didn't work out either. I've decided to add one extra record with a UNION in my query and and extra field to group on. Now I have a page break on the new group, seems to work but makes my SQL less readable... – Mike Dole Jan 05 '15 at 21:07
0

I didn't find a way to solve it with a rectangle triggering a page-break so I decided to add one extra field linetype and one extra record to my query with a UNION.

E.g:

Select 1 as linetype, A.SalesId, B.SalesName
UNION
Select 0 as linetype, A.SalesId, NULL as SalesName

In the UNION query I skip fields I don't really need in that section to keep things readable.

With this new group I can force a new page and I hide rows in my tablix based on linetype enter image description here

The thing I dislike is that my already hard to read sql query is doubled in size but it does the job..

Mike Dole
  • 675
  • 2
  • 14
  • 30
0

I have fixed the problem which is: page breaking is ok on local testing, but don't work on reporting server.

My report structure:

- Tablix
-- Rectangle (page break here)
--- Sub-report1 with visibility expressions
--- Sub-report1 with visibility expressions

Then I've tried to change the structure:

- Tablix
-- Rectangle (page break here)
--- Rectangle1 (another rectangle level)
---- Sub-report1 with visibility expressions
--- Rectangle2 (another rectangle level)
---- Sub-report2 with visibility expressions

And it's fixed both downloading url and viewer.

I hope can help someone who is struggling with this.

hungndv
  • 2,121
  • 2
  • 19
  • 20