SSRS 2008 Conditional Column Visibility Whitespace Issue

To eliminate white space due to hidden columns :

1. in the grouping pane, click on thesmall black triangle and select "Advanced Mode" to show static members in the grouping pane
2. under the column groupings, you should now see a list of gray "(Static)" items. Select the item that represents the column that you want to conditionally hide. Once selected, the property grid window should show the tablix member properties for that static column. In those tablix member properties, make sure to set the Visibility.Hidden expression to the desired condition

By doing this, you will hide the entire static column tablix member and as a resultthe whitespace will disappear.