Parameterized Group and Toggel Visibility in SSRS

Question

i Have Report where i have 5 Groups Every Group is Depend on its upper group and display can be toggled by this report Item.Like Below Image

Now i have Parameter as User Role if i Pass NM then All Group has to Show. if i pass RM then start Visibility from RM. the Problem is if i Pass RM then only Headers are Showing not the Data becasue its Toggle Visibility is Depend on NM which is now not visible.

Please Reply

Answer 1

Please don't waste time because Toggle visibility can not be set dynamically.

Please create different report for different login.

Answer 2

You will want to change your visibility expression for the other groups so that instead of just having NM showing the visibility, it should have a nested iif for RM. For instance,

=iif(Parameters!Value="NM",1,iif(Parameters!Value="RM",1,0))

If the issue is your group visibility and not row visibility then you can change the visibility for the NM group to actually be a row visibility setting versus a group visibility setting because NM is a parent group it may hide it by default. Then you can change your grouping expression to also reflect that it should not group on NM if it has RM parameter.