Create report showing all tasks assigned to Assignment Group A that were submitted by Assignment B

[JTHowe]

I need to create a report that will list all tasks:

• assigned to Assignment Group A; submitted by a member of Assignment Group A
• Assigned to Assignment Group A; submitted by a member of Assignment Group B

I know I could list out each of the members of the Assignment Groups but that means the report would have to be modified every time the Assignment Group was modified.

[Jordan Vignoni · Accepted solution]

You could try creating a script include that queries the sys_user_grmember table.  The condition on your report would then call the script include.  For example, let's suppose your script include is named "getGroups" and the function in the script include is called "getGroupA", the condition would be: