I have report with a Parent row group that I would like to enable or disable based on a parameter. So I went to visibility inside the group properties and set an expression but it hides rest of the table/groups also. 

I want to hide the group and its associated column based on a parameter. Please suggest. Thanks in ad

Hi czarvk,

According to your description, you want to disable or enable group based on parameter values, also the associated column should hide or display, right?

In your scenario, you can specify Group on expression in Group Properties based on parameter values like below:
=IIF(Parameters!ReportParameter1.Value="enable",Fields!SalesTerritoryGroup.Value," ")
Since the associated column visibility is disabled, we can specify each textbox visibility within the column based on parameter values like below:
=IIF(Parameters!ReportParameter1.Value="enable",false,true)

Please refer to screenshots below:

If you have any question, please feel free to ask.
 
Best regards,
Qiuyun Yu

If you have any feedback on our support, please click here.

HI Qiuyun Yu,

Thanks for your response. Actually I am not using a parameter for my visibility expression. For the sake of easy understanding I said so. Sorry for the confusion. I am actually using a field value for grouping. 

This is my group expression for the "SetNumber".

=iif(Fields!flag.Value=1,Fields!SetNumber.Value,1)

Below is my visibility expression for the "SetNumber"

As a result the column set is still showing and hiding the detail of the all the other groups and their associated columns which is not what I want.

I want it to hide the whole set column when the field value is "1" like below.

I set the Visibility property of the group "SetNumber" to hide but that still hides everything like below

Please help. Thanks in ad

Hi ,

Please right click on the set column and set the column visibility based on your above condition

=IIF((expression)= 1, True, False) which will solve your problem.

Please mark as answer if the post solved your problem.