Has anyone found an effective method to expand DRE reports AND limit the number of levels in the expansion?
Specifically, I am trying to build an EVDRE report that expands the rows 2 levels below the selected member with the Parent members after the Children. MEMBERS and ALL allow for a ParentAfter option, but both include too many members in the expansion.
Here is sample of what I am attempting to do:
-
Child A1
-
Child A2
-
Child A3
--- Parent A
-
Child B1
-
Child B2
-
Child B3
--- Parent B
ParentAll
Thanks,
Jeff