CODEWITHSUNDEEP
ssrs-2008page-break
MikeTWebb
MikeTWebb

Reputation: 9279

Inserting a Page break into an SSRS report

I have a report in SSRS that contains 12 subreports. After each subreport, I need to insert a page break so that each subreport starts on a new page and doesn't share pages with the other subreports. Does anyone know how to do this? Thanks

Upvotes: 44

Views: 106882

Answers (7)

Conner
Conner

Reputation: 361

Like other answers mention, I used the "Page break before" option on rectangles/tables, but for some reason it would only break the page if it wasn't at the very top of the (sub)report

Upvotes: 0

Marton Berecz
Marton Berecz

Reputation: 59

Just use the "Add page break after" on the General tab of Tablix Properties.

Upvotes: 2

John Kattenhorn
John Kattenhorn

Reputation: 839

I tried the other answer here but my master report is driven by a dataset so didn't quite work out. This is how I got it to work for me:

1) I put the subreports into different rows on top of same size rectangles inside a Tablix with all the rows belonging to the same row group.

2) I then selected properties of the group, then pagebreak and checked the property pagebreak on between each instance of group.

Upvotes: 3

Kyle Jardine
Kyle Jardine

Reputation: 13

I have made Many reports with a front Page Summary and Page 2 with the Detail. Use the Tablix for the Page Break Tablix > Properties > PageBreak > BreakLocation > Start / End / ......

Upvotes: 0

siddharth
siddharth

Reputation: 19

I came across the same kind of issue but I was able to overcome by below mentioned way. I created a sub report and placed rectangle inside the sub report (page break option checked before) and placed all my sub report content inside the rectangle. This page break works only if the sub report renders any data if not they will be no page break.

Upvotes: 1

dmedz
dmedz

Reputation: 301

Another solution would be to have the subreports placed inside the rectangles. I would imagine this would help you to better control and organize the layout of the report.

Upvotes: 8

MikeTWebb
MikeTWebb

Reputation: 9279

I found an answer. Use a Rectangle at the bottom of each SubReport after all Tablixes and other rendering Objects. Then set its "PageBreak" property to "End". When the SubReport is finished with the Tablix and/or other data objects, the Rectangle forces a page break. Also, a cool feature, if the SubReport returns no rows of data, the page break is not rendered. Therefore, no extra page breaks

Upvotes: 88

Related Questions