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:
- 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
- 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