Timesheet report

M

Mike

Is there a query that I can use to show a timesheet
Hours/employee/project/task

I tried the querys that are in the sdk, but I get
different results than the web page the users key their
time into.

Mike
 
D

Dale Howard [MVP]

Mike --

If you are using Project Server 2003, you could create an assignment view in
PWA that would approximate what you wish to see in your timesheet report.
To do so, complete the following steps:

1. Log into PWA with administrator permissions
2. Click the Admin menu
3. Click the Manage Views link
4. Select the Summary view in the Assignment section and click the Copy
View button
5. Give your new view an original name and click OK
6. Select your new view and click the Modify View button
7. In the Fields section, include these fields in this order:

Task Name
Work
Actual Work
Resource Name
Project
Start
Finish

8. In the Default Group, Sort section, create the following Grouping:

Group by: Resource Name
Then by: Project
Then by: Task Name

9. In the Categories section, make sure this View is included in the
Categories you wish
10. Click the Save Changes button

When you apply this custom View, be sure and select the View Options tab and
to select the "Show scheduled work" option. Scroll to the desired time
period, and then you can then print the View by clicking the Print Grid link
to the lower left of the data grid. Hope this helps.

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
Denver, Colorado
http://www.msprojectexperts.com
"We wrote the book on Project Server"
 
D

Dale Howard [MVP]

Mike --

If you are using Project Server 2003, you could create an assignment view in
PWA that would approximate what you wish to see in your timesheet report.
To do so, complete the following steps:

1. Log into PWA with administrator permissions
2. Click the Admin menu
3. Click the Manage Views link
4. Select the Summary view in the Assignment section and click the Copy
View button
5. Give your new view an original name and click OK
6. Select your new view and click the Modify View button
7. In the Fields section, include these fields in this order:

Task Name
Work
Actual Work
Resource Name
Project
Start
Finish

8. In the Default Group, Sort section, create the following Grouping:

Group by: Resource Name
Then by: Project
Then by: Task Name

9. In the Categories section, make sure this View is included in the
Categories you wish
10. Click the Save Changes button

When you apply this custom View, be sure and select the View Options tab and
to select the "Show scheduled work" option. Scroll to the desired time
period, and then you can then print the View by clicking the Print Grid link
to the lower left of the data grid. Hope this helps.


--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
Denver, Colorado
http://www.msprojectexperts.com
"We wrote the book on Project Server"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top