Wednesday 25 July 2012

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 an parameter called "Extra Field" that will give me option to select the column make visible
    • Select--> allow multiple values
    • Available values: Click Add to insert a new option. In the label <Please select> and in the value field none - if you want a 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. 

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home