RDLC report, How to combine the bottom of tablix with page footer

Question

Help me please. A Tablix has 7 rows but I need to increase height of tablix until it matches the footer. What should I do?

[Edited.]

According to below figure, I tried to insert a lot of blank rows to a Tablix. And I used an Expression for setting visibility each row. Example :

-If Dataset has one record. One Blank row will hide.

-If Dataset has two records. Two Blank rows will hide.

But It is inflexible because some rows aren't a single Line.

Answer 1

Using RDLC 2005 you can simulate this behaviour with:

• a Body section with Body.Height = Page.Height - Footer.Height - TopMargin - BottomMargin
• a Tablix without border
• a Rectangle for every column to simulate with Rectangle.Height = Body.Height; set its RepeatWith property to Tablix

In order to simplify some operations you could put your Total textbox in the Footer or consider it when you build your Body section as explained before.

There is an example of what I mean (Tablix with red border and Rectangle with black border):

Answer 2

Another, though more complicated way, of forcing the height would be to use Subreports for each of the columns.

Each Subreport would list the table contents for that column as a single list.

You could then force height of a single table row to reach the footer... If the Subreport does not require the entire space it will return whitespace

Parent Report

Report 5

Report 4

Results in the following output report