page breaks seem to be a real issue in SSRS, according to the number of posts, but I haven't found a solution for my problem yet.
My report contains a tablix which is used to group the data by keys. The tablix has one column and one row, and this cell contains several subreports which get their data from another table depending on the keys of the groups. This works quite well. However,
I would like to insert a page break in between the subreports. I tried inserting a rectangle with the PageBreak property set to Start and/or End, but this is ignored. Page breaks in the subreports themselves are also ignored. Having the subreports in rectangles
with PageBreak property set to Start or End is ignored as well.
The only way I have found to force page breaks is cross-joining my query of the main report with a table containing page numbers, add the page number field as the last grouping in SSRS and check the "Page breaks between each instance of the group", then
showing or hiding the subreports conditionally depending on the page number retrieved from the database. However, this obviously multiplies the amount of retrieved data by the number of pages and is therefore a rather slow approach.
How can I insert a page break between rows of a tablix or even within one row?
We are using the Report Viewer control in local processing mode
View Complete Post