Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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!

share|improve this question

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.

share|improve this answer
    
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 '13 at 19:50
    
@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 Gan Jun 25 '13 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 Gan Jun 26 '13 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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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