Paginated report- how to avoid a table splits into two pages

[mcantos]

Hello community,

I hope you can help me this time as you did before. 

I have a paginated report that has three different tables with three different datasets. The legend is within the footer because the report can have more than one page. 

The problem I experience is the last row splits into two and continues to the next page. I can't fix the row size because they can grow based on the amount of text.  The page above should end with the dashed bottom border of the row I remarked in the image below.

Is there any feature I can set to accomplish this in each table? 

Thank you!

[mcantos]

Hi @Anonymous 

I finally fixed the issue by adjusting the row size.

Thank you so much!

[Anonymous · Accepted solution]

Hi @mcantos ,

To avoid this, you can use the “Keep Together” attribute for tables that you want to keep intact on a single page.

Open your report in Report Builder.

On the Design surface, right-click the corner handle of the data region, and then select Tablix Properties.

On the General tab, under Page break options, select the option:

Please see the documentation below for more information on this:

Add a page break to a Report Builder paginated report - Microsoft Report Builder & Power BI Report B...

Another factor to consider is line height, try adjusting the line height to fit the page.

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[mcantos]

Thank you @Anonymous for your help. 

It did not work for me and I think is because the tables have two rows: one with the small boxes to the right and another just below it. I tried removing the footer but didn't work either. 

I have another report with one table with one row and seems to work, so...

I also tried to fix the size without success. Any other ideas? Maybe creating two tables instead of one with two rows?

Thank you!!