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

1
votes

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?

enter image description here

[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.

enter image description here

2
reporting-servicesreportrdlcssrs-tablix
Potentially silly question but... I there a reason you're not using an actual footer for the report? - Jonnus
This is actual footer. I inserted it by right click then choose "Add page footer." - Fame th
Some body help me, please. - Fame th

2 Answers

2
votes

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):

enter image description here

1
votes

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

enter image description here

Report 5

enter image description here

Report 4

enter image description here

Results in the following output report

enter image description here