Unsubmited Timesheets in PS 2007

N

Newbie

Hello,
A Project Manager want to list *all* the timesheets which have not been
submited for approval on a specific week.
Is this possible in Project Server 2007?
Thanks
 
J

Jonathan Sofer

You can create a Data Analysis view from the Timesheet Cube showing resource
list on the left and time and timesheet period on the top. Then show the
Actual Work Billable data in the grid.

Important, in order to show all resources in this report even if they have
not reported time, you need to right click on the data grid and go to the
Reports tab and check the box next to Always Display "Empty Rows"

If this data analysis view does not contain all the information you would
like (custom fields, etc) then I think you will have to install SRS
reporinting and take a look at the sample timesheet report that is provided
from Microsoft.
http://www.microsoft.com/downloads/...f9-7028-4b30-99a2-18cb1eed1abe&DisplayLang=en

Hope this helps,

Jonathan
 
N

Newbie

Thanks a lot Jonathan!

Jonathan Sofer said:
You can create a Data Analysis view from the Timesheet Cube showing
resource list on the left and time and timesheet period on the top. Then
show the Actual Work Billable data in the grid.

Important, in order to show all resources in this report even if they have
not reported time, you need to right click on the data grid and go to the
Reports tab and check the box next to Always Display "Empty Rows"

If this data analysis view does not contain all the information you would
like (custom fields, etc) then I think you will have to install SRS
reporinting and take a look at the sample timesheet report that is
provided from Microsoft.
http://www.microsoft.com/downloads/...f9-7028-4b30-99a2-18cb1eed1abe&DisplayLang=en

Hope this helps,

Jonathan
Click to expand...
 
Top