I need to report on the number of hours that have been worked against all tasks within a project, including those tasks that have not yet begun.  Normally, I would pull this info from the Tasks folder underneath the Project Information subsection.  The problem with this is twofold.  First it takes about 3 minutes to pull the info per project (we've even tried using IDs as the links instead of data fields).  Secondly, it doesn't include time that has been entered onto a timesheet that has not yet been submitted.

 My second option is to pull this directly from the Timesheets section.  This report runs very quickly but it lacks the ability to give me a hierarchical view of the tasks (only lowest level tasks are included -- we can live with this!).  The real kicker here is that it doesn't display tasks that have not yet started.

 Any suggestions?

Darlene

 I recently researched this to see if we could pull time before Timesheet approval and there are 2 fields that will do this, one from the Tasks folder and the other from the Timesheets folder.  I put in a request to our documents team to update the mouse over tips to explain better if these were pre or post approval so that change should happen in the next release.

 I'll have to go back in and figure out the name of the field in the Task table but I'm pretty sure it was 'Incremental Work' - test that, it should give you all time entry against a task regardless of timesheet approval.

Hi Steve,

Thanks for your reply.  I went back in and played around but including the Incremental Work value doesn't do what I need either.  For one thing, it removes from the table tasks that have no work (something I don't want to have happen) and second, it seems to present values that don't make sense.  For example, a task has a total planned work of 408 and a total actual work of 1.25 (which I can verify by going into and viewing the tast updates).  Then there is an Actual Work Hours value of 5.00 and an Incremental Work of 18.25.

I pulling the Project Name, the WEB, Task Name, % Complete, Start, Finish, the fields I mentioned above, ETC, and Resource Full Name.  If I could post a screenshot, I would.

Thanks!

Darlene