How to insert a Page Break within Row Group in SSRS 2008 R2
Hi, I have 4 subreports in a table as shown below. i am trying to insert page breaks between each of these subreports: 1: I tried putting all the reports within a rectangle and set the page break property on the rectange, but it didnt work. 2: I tried using the formula(=Floor((RowNumber(Nothing) - 1) )) in group expression, but it didnt work. The reason being, all the 4 rows belong to same group and the expression used inserts the page break between certain number of groups but not within the same group. So if i want to insert the page break between the rows in the same group, how do i do it? Thanks.NC
September 27th, 2012 11:12am

If they are all part of the same group, SSRS will interpret the page break after the entire group....You should try to place every sub report within it's own group. Delete the entire current group setup, and then create a new group per each row. Once you do that, every subreport will be in it's own group, and you can control the page break of each individual group. Andy. Be more than a developer...be a business asset!
Free Windows Admin Tool Kit Click here and download it now
September 27th, 2012 3:45pm

Hi Gownam, From your description, you want to add a page break inside a row group, right? If in this case, you can add page break base on the rows, for example, if you want to each page to display 20 rows, you can add a page break for each 20 row. For the details how to do it, please refer to the link below to see my post: http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/ec487e62-dea3-4d8f-b368-a85ac9296d66 Another way to work around you issue is using different table to display the subreports, and then add a page break for each table, in this case, it looks like add a page break between the rows in the same group. If you have any questions, please feel free to ask. Regards, Charlie Liao TechNet Subscriber Support If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.
September 28th, 2012 2:17am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics