Hiding columns

Hello!

I want to hide/show my report's columns based on a multivalued parameter, but I don't want my table with a "gap" (this is what happens when I use a expression on the visibility property)! Is there anyway, any workaround I can do to achieve this? Is it possible to shrink table size based on this parameter?

Thank you!

A gap will exists if you put the visibility not on the column. if you put the visible / Hide property on the cells by marking them only the cells will be made invisible, but as far as 1 columns still exists, it will be shown in the report.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||Thank you very much Jens!|||

Hello.

I have a similar problem. I can hide my colums by putting the visibility for the column to "hidden". My problem is: How can I unhide the column in the preview tab? What I actually want to achieve is the following: if you click on a textbox in column 1 (column 1 has product categories), colum 2 (the one that was hidden, it contains the product subcategories) shall appear. I assume that it works with toogle items, but when I enter the name of the textbox of column 1 in the toogle item properties of column 2, it does not work.

Can anyone help?

Thanks a lot in advance!