I have a reporting requirement in which I have 3 groupings Group_1 parents -> Group_4 lowest child
I have a groupingID param which is an int that I'm using to show the same report either as region/div or emp/supervisor. Group_1 =totals and Group_4 = Employee and NULL for region/division.
Updated requirements want me to not show toggle button at Group_3 = Region level if GroupingID is set to region/division. As region is the lowest level. While still show toggle "+" button if grooupingID param is emp/supervisor.
I tried this expression for "row visibility but to no luck. =iif(Parameters!GroupingID.Value=1,True,iif(Fields!Group_4.Value=Nothing,True,False))
This expression shows + for Reg/division report.
Data Architect proposed a solution which solved it. Add a new column in tablix to the left of all the groupings. Depending on which group level you wish to toggle (in my case at group_3) just use the text box (to the left) of group_3 text box as 'toggle item by' in the properties for group_4. This solved the issue I was having.