Server Reports

J

Jay

Hi. I need to create a report in Project Server or find a way for managers to
be able to check what team members have/have not updated their tasks in
Project Web Access. This report should be able to go across projects - so not
just the project manager for the individual project.

Does anyone know how to do this?
 
J

James Fraser

Hi. I need to create a report in Project Server or find a way for managers to
be able to check what team members have/have not updated their tasks in
Project Web Access. This report should be able to go across projects - so not
just the project manager for the individual project.

Does anyone know how to do this?
Click to expand...

In 2003, this report is a little bit tricky to write, but not
impossible. Maybe a full day's work to get the SQL queries correct.
Start with MSP_WEB_WORK and go out from there.

In 2007, this report is much harder to write, as some of the
unpublished task update data is stored in binary form in the database,
and all of it is in the published database, which MS strongly
discourages reporting against.

So yes, I know how to do this, but it is not work that I am able to
give away. Contact me directly if you would like to talk about how my
company can help you with reporting.


James Fraser
[email protected]
Occam Group, Ltd.
Microsoft Gold Certified Partner
Minneapolis, MN USA
 
Top