In SSRS reports you can easily determine which table columns are visible by default. Not everyone knows that you can give user possibility to choose which columns should be visible.
To do this, you have to create additional parameter (eg. Columns), where you can put values to every column that visibility will be possible to control by end-user:
Label field is a label that can be choosen by user, Value is internal name. You can put custom name in both, you will map value names with columns in tablix properties.
Next, select Column visibility option in each column that you want to control:
Put an expression into dialog box:
You must set green underlined parameters: parameter name and one of parameter value which will control current column. Above expression is correct for multiple value parameters.
After you set expressions for “Hidden” parametrs in every columns (if needed) it will work as follows:
