I have an SSRS report for an Invoice and it generally works perfectly but occasionally it will page break in the middle of a row in the main Tablix. The row will split and leave part of the text on one page and the rest on the next. The Tablix has no inherent page breaking. I was just relying on it to break between rows (regardless of which rows). There are a couple rows that repeat on each page. There is a second Tablix below the Detail one with Summary Totals. This is just some background info about the report. I'm relatively new to SSRS and haven't had the greatest luck with the formatting thus far.

Thanks for any help!

2 Answers 2


@matt you might want to adjust the tablix or row KeepTogether property. This affects how it tries to have all rows/table on the same page.

  • 1
    Travis, I looked through all the rows and tablix settings and adjusted the KeepTogether property but still ended with the same result. Have you dealt with reports with open-ended tablix's (no page breaking) that overcame this issue before? Thanks for your insight.
    – Matt
    Jun 25, 2013 at 19:50
  • 1
    @Matt I had the same issue before. In my case, adjusting the KeepTogether property appropriately address the unintended rows/groups/tables split into different page of the report. One thing I want to point out is, it usually happen with report that involves multiple groups or tables, as oppose to only one big table.
    – Travis
    Jun 25, 2013 at 20:14
  • @Matt I just noticed the SQL 2012 RTM CU8 and SQL 2012 SP1 CU4 fixes the KeepTogether for SSRS 2012. I am not sure it applies in your case, just thought you may need to be aware of that. Here is the KB link support.microsoft.com/kb/2832818
    – Travis
    Jun 26, 2013 at 22:36

I had a similar problem however mine was that the page break was at the wrong place and thus messed up with my report.

How I ended up solving it was to get an estimate on how many rows I can fit on a page and than using the NTILE() SQL function to divide the results into multiple pages by adding a "page number" to the resultset.

Than I've set the field to be used a s a parrent row group and forced a page break after each group. It's not perfect but it worked out for me.

Note that you may have to resort to using a cursor to solve the page breaks.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.