PS 2007 and Reporting Services - Summary Tasks and Sub Tasks:

[jleifb]

I am haveing difficulty trying to create a report that will look like the
project plan itself. The difficulty I am having is matching the summary
tasks with their subtasks. I can tell which ones are summary tasks but
please let me know an easy way to display the summary task and its sub-tasks
underneath it to mimmick the Project 2007 plan.

 

[Marc Soester [MVP]]

You have several views which allow you to list your summary tasks and sub
tasks. I generally ensure that all summary tasks are bold, which
differenciate them from sub tasks
hope this helps

 

[jleifb]

Would you have a sample query that would show this?

 

[alexb]

Hi,

In the reporting database you should be able to associate the tasks
with the subtasks in the dbo.MSP_EPMTask table by joining the TaskUID
and TaskParentUID columns. Depending on the level of nesting in the
schedule, the query is likely to get really complicated very quickly.
There are two other columns in there you need to take into account:
1. TaskIsProjectSummary - True for the project summary task, will be
false for all other tasks. This will be the top of your tree
2. TaskIsSummary - True for all summary tasks, false for all non
summary tasks.

Hope this helps.

Alex.

 

[Marc Soester [MVP]]

thanks Alex

 

[alexb]

Your welcome my friend

thanks Alex

 

[Roberto Gattoni]

Dear Sirs,

Please, in order to build some reports, we need to know, in the Reporting Database, if a task is a "child" inserted project plan on a master project plan.

So, in this situation, consider that we have the following structure on a master project file:

ID Level Taskname
=========================
0 0 Master project Task
1 1 Task 01
2 1 Task 02
3 2 Task 02.1
4 1 Inserted Project

So, how can we detect, on the tasks list of the master project, on the Reporting database, if the task ID = 4 is related to an inserted project.

Is this information available on some view or table on the Reporting database?

Thanks a lot!

rga.

I am haveing difficulty trying to create a report that will look like the
project plan itself. The difficulty I am having is matching the summary
tasks with their subtasks. I can tell which ones are summary tasks but
please let me know an easy way to display the summary task and its sub-tasks
underneath it to mimmick the Project 2007 plan.

On Friday, September 25, 2009 11:46 PM Marc Soester [MVP] wrote:
You have several views which allow you to list your summary tasks and sub
tasks. I generally ensure that all summary tasks are bold, which
differenciate them from sub tasks
hope this helps
--
Marc Soester [MVP]
http://www.i-pmo.com.au


"jleifb" wrote: