AnsweredAssumed Answered

SQL Query - Resources, Allocations and Actuals on Project

Question asked by jschuff on Jan 17, 2011
Latest reply on Jun 20, 2013 by petermaino
I am trying to write a query that will pull the projects that we have in the system that are active and show a count of their resources on the team. From that count I want to be able to show how many of the resources on the team tab for that project are actually allocated on the project and how many are recording time on the project.

I am having some trouble finding a way to link resources, allocations and actuals to a project in this manner. Has anyone tried to do this before? Or does someone have any tips for how I could accomplish this?