How to shrink 'list' object in Reporting Services

Question

I have a table and an associated chart contained within a 'list' object in SSRS 2005. I am using an expression to determine the visibility of the table and chart, however when the table and chart are not visible an ugly large blank space (where they would otherwise have been rendered) appears in the report.

Is there any functionality to 'shrink' the list object if only some of the objects are rendered?

For example, I have a list with 3 items:

A
B
C

Item B does not meet the visibility criteria, so it's visibility is set to false. The outcome is:

A

C

But I want:

A
C

Any suggestions?

Answer 1

Im not sure i completely understand the problem, but, why don't you filter the results rather than change their visibility?. I had similar problem, my solution was redo the report, i found that the visibility is quite problematic than useful.

Answer 2

To my knowledge List height automatically grows and shrinks based on the visibility of the controls in it. Make sure that you are setting the visibility to entire control if it is a table or chart.

Answer 3

Another solution would be to display your items within a table, and the table is placed inside the list.

1. Place each of your itmes in one table row (table header).
2. Set the visibility of your table rows according the visibility of your items.

If one item's visibility is set to "hidden", the whole table row will be hidden and won't be displayed at all.

Best regards