Hello forum, I'm trying to create a set of livereports that allows a user to select a group leader and it will display all the groups (and subgroups) for that leader and members of each of those groups. I have the basic report and sub-reports written, but I'm having trouble with the SQL that will select all groups and most importantly all subgroups for a leader. Does anyone have sql for that? Thanks in advance for your help.
