ssrs hide column group based on input parameter SQL Server 2008 R2

Question

I am building a report in SQL Server 2008 R2 using Report builder 3.0. I have a column group Called committee which has values Committee1, Committee2, Committee3. Column Group committee expands into three columns Person, Contact, Company.

Input to report is based on multiselect parameter.

Reference: show/hide columns in SSRS report 2012 based on Multiselect parameter

My requirement is if Committee 1 is selected from input, the report should show the column group committee not Committee2 and Committee3. I know how to show or hide columns based on input parameter but not for column group.

Please help.

Check the "Advanced" box to view Column Groups, select one, and modify the "Hidden" property same as for a column. — Tab Alleman, Apr 07 '15 at 14:10
But you say " I know how to show or hide columns based on input parameter". The expression is exactly the same, you just do it on the column group instead of the column. — Tab Alleman, Apr 08 '15 at 14:35
ok.. thank you.. I was under impression that there is a separate expression for column group.. it is working.. — AnandhaSundari M, Apr 09 '15 at 05:47

score 0 · Answer 1 · answered Apr 08 '15 at 11:20

0

Right click column->colmun visibility->Show or hide based on and expression Then write your show hide statement.

answered Apr 08 '15 at 11:20

I dont know how to write the statement. – AnandhaSundari M Apr 08 '15 at 11:47
have a look this link or search in google as "ssrs column visibility" http://bhushan.extreme-advice.com/conditionally-setting-column-visibility-in-ssrs/ – Apr 08 '15 at 13:14

ssrs hide column group based on input parameter SQL Server 2008 R2

1 Answers1