Report that shows Count of Users within a specified Group

Does anyone have a LiveReport where you can select a group (or type in its ID), which shows all of the members of that group and its children? I would like to be able to query and get a count of the number of users in high level groups that include many subgroups, etc.Thanks in advance.Regards.

Find more posts tagged with

Comments

Tech_Writer_(edscauser5_-_(deleted))

You could import the report. It includes a main report which lists all the groups and a sub report which lists all the members. My database is sql server 7.0. If you use Oracle, you may need to change "+' '+" to "||' '||" in the sub report.

eLink User

Message from Drane, Matthew via eLinkThanks for the report.....how could it be modified so that it would includethe children's children and so on of the group you select, so that you couldget a combined listing of everything below that group? Thanks and regards.-----Original Message-----From: eLink Discussion: Livelink LiveReports Discussion[mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Friday, April 19, 2002 4:41 PMTo: eLink RecipientSubject: I have one...I have one... Posted by EDSCAUser5 (Pan, Ping) on 04/19/2002 04:36 PM In reply to: Report that shows Count of Users within a specified GroupPosted by HASBRO011 (Drane, Matthew) on04/19/2002 01:08 PM You could import the report. It includes a main report which lists all thegroups and a sub report which lists all the members. My database is sqlserver 7.0. If you use Oracle, you may need to change "+' '+" to "||' '||"in the sub report. Attachment Links: GroupList.rpt (2 KB) _____ [To reply to this thread, use your normal e-mail reply function.] Topic: Report that shows Count of Users within a specified Group Discussion: Livelink LiveReports Discussion Livelink Server: Knowledge Center