Reporting on Parent Groups within Parent Groups

[amyd]

We have set up our assignment groups into tiers and I am having some problems when it comes to reporting. I am setting up dashboards so that Upper Management can see all the tickets that are assigned to their various groups.

Our Assignment Group Structure is set up like this:

Parent Group A (tickets do not get assigned to this group)

      Sub-Parent Group 1 (tickets do not get assigned to this group)

                  Child Group 1

                            user 1, user 2, user 3, etc.

                  Child Group 2

                            user 1, user 2, user 3, etc.

        Sub-Parent Group 2 (tickets do not get assigned to this group)

                  Child Group 1

                            user 1, user 2, user 3, etc.

                  Child Group 2

                            user 1, user 2, user 3, etc.

What I want to be able to do is choose Parent Group A and have it show the tickets that are assigned to the all the groups beneath. If I choose a Sub-Parent Group (for lack of a better term) I can see all the tickets assigned to each child group. But if I pick Parent Group A, it doesn't.

I have looked around, but have been unable to find a solution. Any help is appreciated.

[Deepak Ingale1]

If it is kind of static page, i would go and configure a report like give me all the tickets where assignment group.parent == 'sub parent' || assignment.group.parent.parent == 'parent'

However, i it is kind of interactive way, you may need to do build either ui page / ui macro / dashboard which would give records based on group selected