Report that only shows projects that have tasks assigned to certain role ids

[StephaneePu]

I am trying to build a project report that only pulls projects that have tasks assigned to a specific group of role ids within that project. The goal is to show the amount of projects a specific team is included on in a fiscal year. 

[Kurt_Jones]

Stephanee, 

Something like below:

It's a Task Report, grouped by project name (you can group by role as well).  For filters, use AssignedTo->Role ID and input the role (I used Project Manager, but you can list as many roles as needed), I also had filter that Project status not equal to Complete, and Task status not equal to Complete.