Tracy,
this is very helpful, thank you. I had my consultant help me with a similar report that shows incomplete items using the user wildcard in the manager ID field, so my boss only sees the incomplete work for her direct team.
I used text mode to share columns--my team works on both tasks and issues regularly. I also use a report prompt so that she can look at one individual user or all of us at once. I attached a screenshot in case this is something you could use, as well.