Hide / show column in SSRS using parameter

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:

Bez tytułu

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:

Bez tytułu

Put an expression into dialog box:

Bez tytułu

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:

Bez tytułu

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s