SSRS Report: Column visibility according to selected parameter

Scenario:
Say for example, I do not want all the columns to be visible in the report by default. I want an option for some columns to be visible if I select them to be visible.

Solution:

  1. Create a parameter called “Extra Field” that will give me the option to select a column from the list of columns. When a column is selected then it will show the column from the tablix
    • Select–> allow multiple values
    • Available values: Click Add to insert a new option. In the label and in the value field none – if you want an option none. Otherwise, in the value field enter the exact data field name from the data set
  2. Now select the column–>Right click and select–>Column visibility. Now in the expression type a command which will join the all the parameters value first then will look for the exact Data Field you want to make visible.
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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s