Missing Timesheets Report

[jon_baldan]

Hi

I have been setting up my Project Server 2003 and MS Project 2003
across my team over the last 2 months and finally gone live this week.

Our configuration is one box with Project Server and SQL Server.
Because of our 3rd party agreements, all I can have is a read access to
the SQL database through ODBC (i.e no Enterprise Manager or Query
Analyser). Within Project Server, we have Managed Period activated and
these relate identically to our current timesheeting periods within the
company (weekly).

My query is in regard to being able to identify people who have not
completed timesheets. Basically, I need some form of report that tells
me for all active work resources the amount of time they have saved on
their timesheet but not submitted, submitted but not approved, approved
and rejected time on a project by project basis for a given Managed
Period. I have searched through a number of discussion boards but had
no luck in working out an easy way. I am dreading the thought of having
export all the info into Excel on a weekly basis to do this.

I have looked at some 3rd party plug-ins (such as EPK) and they have
these functions, but I don't have the authroity to spend any further
money. This seems to me to be a pretty basic function for a Project
Office to monitor and I am a bit surprised not to find it in the
off-the-shelf product.

Has anybody else come across this issue and if so, have you worked out
a way around this?

Thanks in advance.

 

[Steve]

I have done this (written SPs to pull all of this information and then
written SRS reports to display the results) but there is significant
work that needs to be done in the way of SQL queries and the like. It
is more complex than can be explained easily here, and to be honest,
more work than I (or probably anyone else for that matter) is willing
to post for free.

If you're looking to do it yourself and not hire someone to do it for
you, I will say that the Project Server DB guide is a wealth of
information and while it's not always 100% accurate, if you look
through it, keeping in mind the kind of information you are looking to
pull, you will find your answer.

Hope that points you in the right direction.