Reporting on Pending Task Approvals in Project Server 2007

[rebecca]

I'm hoping someone out there has had some new success pulling an SSRS
report for tasks waiting for approval.

Any new thoughts? I don't see an assignment transaction table in our
PS reporting database.

Thanks!

Rebecca

 

[JavaJoe]

I too would like this reoport. Is there a standard way to get this out of
the system,

 

[Ruwan Fernando]

Please see the post at the following location -
http://projectserverblogs.com/index.php?paged=4&s=statusing

There is a table described later in the page called MSP_ASSIGNMENT_TRANSACTIONS which appears to have some of the information that you want. Note that this is in the Published database. Therefore the information is harder to make sense of than what is typically found in the Reporting database.

However, by connecting the following tables I think most information can be retrieved.

* MSP_ASSIGNMENT_TRANSACTIONS (mat)
* MSP_PROJECTS (mp) on PROJ_UID with mat.PROJ_UID
* MSP_TASKS_SUBMITTED (mts) on TASK_UID with mat.TASK_UID
* MSP_TASKS (mt) on TASK_UID with mts.TASK_published_UID
* MSP_RESOURCES (mr) on RES_UID with mat.ASSN_TRANS_SUBMITTER_RES_UID
* MSP_RESOURCES (pm) on RES_UID with mat.ASSN_TRANS_APPROVER_RES_UID

Hope this helps!
Ruwan