How to create Actual Time report?

J

Jack Kohn

We want to generate a printed report showing the Actual Work (i.e.,
time entered via the PWA timesheet) for each resource on each
project/task.

We are trying to reconcile time entered into Project against time
entered into our old time-tracking system. We simply want to check
that team members are entering time correctly in both systems.

This seems like it should be really simple, but we've spent many hours
on this with no solution yet. Many Project reports we've tried show
weird numbers like 0.97 hrs and 4.53 hrs, like the numbers have
already been run through MS Project's scheduling engine.

Thanks in advance!

-jmk
 
C

Colin Anderson

We have had to develop our own report for this purpose.
This requires som advanced SQL queries, where we save last
week's status and compare with the new status.
The problem is complicated as Actual Work typed in via
Web Access is not stored in the same way as when it is
typed in via the Project client.

Have fun.....
 
J

Jack Kohn

Colin -

Thanks for the feedback. It wasn't what I wanted to hear, but it sure
beats barking up the wrong tree!

Take care.

-jmk
 
B

Brian Gibson

Is it best practice to report directly from the SQL tables? We are having
trouble producing a report within Project using View | Reports.We are trying
to develop a report that looks at a specific week (current week?) and
categorizes the hours work on a task based on Enterprise fields values
(Expense/Capital Expense) for that task by resource.

The report looks like this:

Resource Name
Project Name

Expense | Capital | Total
Sun
Mon
Tues
Wed
Thur
Fri
Sat

If it is proper to report against the SQL tables, what table(s) should we
use to get daily actual hours worked by resource. I understand this may not
be as straight forward as it might seem. Would you elaborate a little more
on your experience in developing your reports? Particularly the level of
effort to get it done.
 
Top