How to Group by User Defined Groups (Crystal Rpts 10 to ECC 6.0)

Hello All:

I'm tasked to write a Crystal Report that groups data on User Defined Groups. The problem is quite interesting, the need for this should also be obvious.

Exhibit A: A screenshot of our User Defined Group as viewed in ECC 6.0.

My screen snippet is here:

http://picasaweb.google.com/cincypiper/ControlCenterFun#5302004143466767234

My task is to create a Report that groups host managed objects by the groups you see in my Control Center Screen snippet above.

So, in my screen snippet you see:

Line Of Business Name
--Application Name
----Environment (Prod, Test, UAT, DR...)
------Host1
------Host2
------Host3
------Hostn.....

I note that SRMGroup is a self-joined table, using ParentGroupKey. Crystal 10 doesn't always see the GroupKey and ParentGroupKeys as a self-join. I note also that "LevelsBelowRoot" and "IsBottom" or "IsTop" can be used to programmatically walk a tree, but I'm certain you understand my question by now.

Using Crystal 10, I really don't want to create X levels of subreports that are hardcoded to look for specifics in my user groups. Must I?

Thank you in advance for your insights,

Mike Horvath
Data Storage Admin