Summary Task in Reporting DB

[MSPLearner]

I would like to write a SQL Query using MS Access to select tasks (from
emptask table) and all associated summary tasks. This is for a single
project. I am looking for help understanding the relationship between summary
tasks and non-summary tasks within the reporting DB. I believe I need to
"walk" up the hierarchy from a task to one or more summary tasks (outline
level).

The report row would look something like this:

Project, Task-A, Non-Summary Task1, Non-Summary-Task2 ....
Project, Task-B, Non-Summary Task5

Any help appreciated.

 

[Stephen Sanderlin]

Unless my recollection is incorrect, TaskParentUID in
MSP_EpmTask_UserView and MSP_EpmTask should hold the GUID of a
subordinate task's parent task.


--

Stephen Sanderlin

Principal Consultant

MSProjectExperts



For Project Server Consulting: http://www.msprojectexperts.com

For Project Server Training: http://www.projectservertraining.com



Read my blog at: http://www.projectserverhelp.com/

Join the community at: http://forums.epmfaq.com