开发者

Inserting a Page break into an SSRS report

I h开发者_开发技巧ave 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


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


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.


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.


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


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.


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 / ......


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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜