Make row occupy space avaiable

Question

How can I make a row of a tablix occupy the remaining space of a page?

Things I tried:

• Create a new empty row and adjust its height to occupy the page, but this row has a fixed height meaning if I have more data the table will expand to the next page
• I changed CanShrink and CanGrow without avail
• Changed the cell height instead of row height it gives the same behavior as before

I'm afraid it won't be possible to do this.

Answer 1

Only if the report takes only one page

One way to do this is to separate the totals into a different table and use rectangles to simulate the columns.

Found a workaround that works for multiple pages (almost)

• Place the 1st table contents inside a rectangle
• Enable Add a page break after, in the rectangle properties
• Place the totals outside the rectangle
• keep using rectangles to simulate do columns (those rectangles need to be inside the rectangle that breaks the page
• Done