I have 6 tablix on a report. They all use the same embedded dataset.
I am trying to get rid of the white space that occurs in my report when hiding tablix based (CountRows() = 0). Though I am hiding each of the six tablix based (CountRows() = 0) inside the row properties, I am still seeing white space all over the place.
I found on Stack Overflow that I need to nest my 6 tablix inside of another tablix (that has no data set), in their own prospective rows. I need to hide their prospective row's base on the (CountRows() = 0) being returned in each of the 6 tablix.
I created my empty dataset tablix and called it "TablixContainer"
This tablix has 6 rows.
- Row one of "
TablixContainer" contains my nested "TabixMiscAllowance" tablix with dataset "BalanceSheet" - Row two of "
TablixContainer" contains my nested "TabixExpenses" tablix with dataset "BalanceSheet" - Row three of "
TablixContainer" contains my nested "TabixTransportation" tablix with dataset "BalanceSheet"
... You get the concept.
- In the visibility property, of Row one of "
TablixContainer" to write an expression based on "TabixMiscAllowance" tablix (with dataset "BalanceSheet") returning (CountRows() = 0) - In the visibility property, of Row two of "
TablixContainer" to write an expression based on "TabixExpenses" tablix (with dataset "BalanceSheet") returning (CountRows() = 0) - In the visibility property, of Row three of "
TablixContainer" to write an expression based on "TabixTransportation" tablix (with dataset "BalanceSheet") returning (CountRows() = 0)
and so on... through to row 6.
I don't even know if this will get rid of the white spaces but I'd like to try it. BTW... Rectangles do NOT work...
