Rectangle or Border look alike behaviour on SSRS report

Question

How can I have fixed rectangle inside the report body for every page ? I am placing a tablix, after that a matrix inside that rectangle. I have attached pictures of my ddl design view, pdf view and desired result layout. So far, I have tried to use fixed tablix size by using sql insert empty row. But this way, I wasn't able to put my matrix inside it. By simply using rectangle, since the rectangle is fixed sized and I am getting problem when my tablix has more data and it is pushing down the rectangle if I have some space below my tablix and matrix.

Any insight will be greatly appreciated.

Answer 1

In your Report Properties, set the ConsumeContainerWhiteSpace setting to true and make your Rectangle as large as it need to be on a page. In doing this, the tables will grow into the white space with each row and not push the bottom of the rectangle until the table is too large to fit.