Hierarchical View Not Needing Node - How To Solve?

Question

We have a hierarchical view with expandable nodes where column A expands to show column B and B to C, etc. We have a special case where we know that there will be only one child in column B for each value in column A so we want to show B for each value of column A but still be able to expand column B. How can we stop B from being expandable and instead always showing the column B value?

Answer 1

Hi David,

From your description, you want the column A and B always be displayed when the report run and the column C to be hidden when the report initially run and can be toggled by the column B, right? In this case, we can drag the column C to the tablix, and then add row group for it, the parent group is column B, and then insert a column in the left of the column B inside the group, display column A in the new inserted column. Then right click the Details in the Row Groups pane and select Group Properties to set its can be toggled by column B. The screenshots below are for your reference.

Reference:Add a Visibility Toggle to an Item (Reporting Services)

Hope this helps.

Regards,
Charlie Liao

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

---

Charlie Liao
TechNet Community Support