When having multiple grouping and totals for each grouping in SSRS reports, the row visibility property cannot be used to hide or show based on certain conditions
In such scenario, the split cells functionality can be used. Once we use the split cells, then the row visibility property will be available.
So if we have 3 groups hierarchy, we should first do the group by for the first required column, add totals and then split the column. Now the row visible property will be available. Set the required expression for showing or hidding the group.
Again do the grouping for next one and follow the same steps as above.
Once a new group is added, the previous group row visibility will not be available.
In such scenario, the split cells functionality can be used. Once we use the split cells, then the row visibility property will be available.
So if we have 3 groups hierarchy, we should first do the group by for the first required column, add totals and then split the column. Now the row visible property will be available. Set the required expression for showing or hidding the group.
Again do the grouping for next one and follow the same steps as above.
Once a new group is added, the previous group row visibility will not be available.
