Good morning,
I am working on the backend queries that will produce the timephasing for Actual Work in MSP 2007. (The Web Work tables from MSP 2003, have been eliminated in MSP2007.)
I can gather information from total actual work hours (approved hours)in the project fields. However, if the projects have been active for more than 30 days, I would like to timephase it.
We can do similar thing in PWA. However, we would like to be able to replicate the reports that we wrote in SQL
I plan to use the tables such as projects, assignments, resources and tasks. However, I am uncertain how to join the timesheet table into this scenarios.
Anyone has some clues to this question, I will be very much appreciated. Thanks
I am working on the backend queries that will produce the timephasing for Actual Work in MSP 2007. (The Web Work tables from MSP 2003, have been eliminated in MSP2007.)
I can gather information from total actual work hours (approved hours)in the project fields. However, if the projects have been active for more than 30 days, I would like to timephase it.
We can do similar thing in PWA. However, we would like to be able to replicate the reports that we wrote in SQL
I plan to use the tables such as projects, assignments, resources and tasks. However, I am uncertain how to join the timesheet table into this scenarios.
Anyone has some clues to this question, I will be very much appreciated. Thanks