Create a Group Membership Report
Created: 15 Feb 2013 | 2 comments
I have been trying to figure out a way to create a report in SD 7.5 report designer that will show me the list of groups that have membewrs assigned to them and also list those members for each group. Output Example would be:
Support:
Joe Schmoe
John Doe
Support 2:
Jane Doe
Janet Schmoe
i do not have access to the backend of SQL for our implementation so I have no idea what the table or field structure (data dictionary) is for the SD schema.
The one script I did try was Select * From [Group] order by "group name" however this did not provide the desired results.
Can anyone assist me with this?
Thank You
Discussion Filed Under:
Group Ownership:
Comments 2 Comments • Jump to latest comment
I just tested this on my 7.5 install, but I imagine it would work with 7.1 as well. I don't think any table names changed. Looks like you're using 7.5 though, so it should be fine. A quick note of caution. If you have a ton of users, this may be a really big report. You could easily add a where clause to leave out the 'All Users' group if that helps.
If a post solves your issue, please mark it as a solution. It makes these forums better for everyone.
Works like a charm, perfect, thank you so much.
Would you like to reply?
Login or Register to post your comment.