3

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!

Kin Shah
  • 62,545
  • 6
  • 124
  • 245
Matt
  • 31
  • 1
  • 1
  • 3

2 Answers2

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.

Travis
  • 2,345
  • 2
  • 20
  • 25
0

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.

Toni Kostelac
  • 193
  • 4