How to decrease the height of a list row containing a tablix ?

Question

Hello,

 

I have a list containing a tablix in its second row and a group on that row.

In the tablix I have a few rows which can be hidden based on the value of user parameters.

My problem is that the height of the list row never decreases bellow the value specified in the rdl living blank space between group entries when the user hides to much rows.

If I set the height of the row below the minimum height the tablix can expand the rendering is ok in Visual Studio and report server but when exporting to Excel, the heights of cells for those rows are far too small.

 

I have set the values of CanGrow and CanShrink properties of all the textboxes of the tablix rows to true but it did not change anything.

 

Does anyone has an idea of how I can resolve this problem ?

Please let me know if my explanations are not clear.

Thanks.

 

J-Christophe.

Answer 1

Hi Christophe,

If you hide the rows, what about filtering these rows in the dataset level by the user parameter? If so, there is no space for the hidden rows on your report body. If this doesn't help, please provide more details.

Hope this helpfully,

thanks,
Jerry

Answer 2

I think the issue is that a list/tablix can grow to fit in any rows/columns, but it can not shrink to wrap around the tablix. So when you create the tablix, the list is a big as the entire tablix when all rows are shown. You can not make it any smaller than that.

So what the OP wants is for the list to shrink to fit the tablix excactly. And for this i do not know if there is a way to make it shrink. I kind of have a feeling there isn't any. At least I don't know any or can't find any.

On second thought Jerry's way could do the trick. It depends if the rows you have are static, with that i mean they are made by you and not based on say categories from your datamodel. In other words, did you manualy create the rows or not? If you did, then Jerry's way does not work. If you didn't create them then it will not work.

Can you give some more information about that? Maybe a screenshot of your tablix.

Answer 3

Thanks for the answers.

You are right Ferry. The rows I want to hide are static.
This is a screenshot of the list: http://yfrog.com/5ylistlj
and the detail of the nested tablix: http://yfrog.com/bftablixj

As you can see, the 3 rows containing HORAIRE, ABSENCE and SYMB were created manualy.

So you think it is impossible to decrease the list row height ?

Jerry, I tried the way you suggest (in fact, HORAIRE, ABSENCE and SYMB are the different values of a dataset column). And using a group on this column worked fine. But then I faced another limitation of SSRS 2008: you cannot hide a static column (ie. a TablixCornerCell). It is a bit complicated to explain why I needed that but the only workaround I found was this nested tablix.

Answer 4

As far as i know there is no List(Tablix) or Rectangle property to allow the increase or decrease of the height and width. So that would be a no. :[

Answer 5

So, I will have to find another way. Using a group on a single line and find another workaround to display the optional columns...

Thanks again Ferry.

Answer 6

You're welcome.

Answer 7

you could try this as a solution:

basically set the visibility condition on the whole row, not just on the contents of the row.

http://www.sqldev.org/sql-server-reporting-services/hidden-rows-still-displayed-9660.shtml

note: this worked OK for me, when set on the Heading rows of a tablix

but still leaves a tiny gap, where the hidden tablix is.

for hiding the data rows of the tablix, I just clicked on the black triangle in bottom-left of the RDLC editor,

selected Advanced

and then selected Row Groups -> Details, and set HideIfNoRows to be True.