Non approved work in Project 2007

[RainieroDin]

Hi, we recently moved from Project 2003 to 2007, and we have a report that
shows the work which has not been approved yet by the project managers. I've
been looking for a way to retrieve this information in project 2007 (through
webservices or directly from the database). Where can I get this information
from? Thanks in advance

 

[Marc Soester [MVP]]

Hi RainieroDon,

Microsoft actually offers a Project Server report pack that you can
download. This is a good starting point.
Check out this site, it has a lot of content that you may be looking fo
http://blogs.msdn.com/project_progr...rver-2007-report-pack-ii-the-top-reports.aspx

Hope this helps

 

[RainieroDin]

Thanks for your reply Marc, I tried the report pack but couldn't find the
information I was looking for. The Statusing webservice provides the
ReadAssignmentHistory method, and the ASSN_CHANGE_DATA column seems to
contain the required information (its value is changed every time I report
work), but it's a byte array, is there a way to extract the information from
this column? Should I try something else? Thanks

 

[Jonathan Sofer [MVP]]

I have not seen or heard of an easy way to extract pending hours from My
Tasks/Updates in PWA. The data does not seem to be available in the
databases in a readable manner.

Have you tried posting to the developer newsgroup to see if there are any
solutions out there?

Jonathan

 

[RainieroDin]

I'm going to post in that group and see what happens, thank you very much!