Sometime, we have a long list of columns in our report that is required to show more information on report. But problems come to that point when we have to restrict only selected columns in export/print. We can achieve this by giving a multi-valued parameter to hide the selected columns on demand. Let’s start with following steps:
Do not forget to check “Allow multiple values” option.
Step 2. Specify list of column names
that you want to include to hide on demand.
Step 3. Now select individual applicable column one by one
and open its Column Visibility option. Refer Image-3
Step 4. Under each applicable column Visibility property, put a expression like following. Refer Image-4
To discuss above expression:
· Join(Parameters!p_column_name.Value,",") will join all the selected parameter values delimited to a character (“,”) and will retrun a string
· .Contains("Employeeid") will return true if the given input value exists in the string otherwise will retrun false.