Hiding and shrinking the width of the Column in SSRS 2008

Hi,

 We recently had a requirement wherein we were hiding few columns of our SSRS report dynamically based on value of a parameter.

The problem was that the hidden column although not visible was still consuming the space.

To solve this issue

• Select Advanced Mode in the report Column Groups
  

  
  

• Select the static column referring to the column we want to hide and set its Hidden property
  

The helpful post

http://blogs.msdn.com/b/robertbruckner/archive/2010/05/02/report-design-shrinking-hidden-static-columns.aspx

Bye.