Create a Task Finsh/Start Date viewable in Project Center

[Erin]

Hi all --
perhaps i'm having a brain freeze -- but i'd like to be able to create a
view in PWA that shows the tasks in my enterprise templates (for each project
based off tihs template) and the start and finish date for each task. It
appeared that I could use the Tasks radio button when creating a view - and
choose Project, Task name, Start and Finish -- but then there was no way for
me to see that view in the Project Center -- I can only see project center
views -- is there a way to grab these fields from creating a report within
the project center fields avail? My company needs project metrics based off
these fields so I'm tasked to 'hurry up' and get this done


ps -- in my global template -- I'm simply using the "start" and "finish"
columns for the dates only --

Thanks in advance,

(e-mail address removed)

Erin

 

[Dale Howard [MVP]]

Erin --

In Project Server 2007, you would need to do several things to create this
View:

1. Create a master project containing each of the projects built from the
enterprise template.
2. Save the master project in the Project Server database and then publish
it (you WILL NOT have the duplicate assignment issues as with Project Server
2003).
3. Create a detailed Project view (not a Project Center view) containing
the fields you wish to see.
4. From the Project Center page, click the hyperlink for the master project
and then apply the new detailed Project view.

If this approach is not satisfactory, then your alternative is to use a
third party database reporting tool such as SQL Reporting Service or Crystal
Reports to extract the data from the Reporting database. Hope this helps.

 

[Erin]

Dale,

too bad i'm locked from '07 at the moment (don't ask why) -- i have SRS --
so basically with the older version i need to use SRS instead of PWA -- I had
attempted to create that from MSP_TASKS and the other project tables it
arranges the tasks funny -- should i order by Proj ID in the MSP_TASKS table
you think to get this to arrange correctly?

thanks

-erin

 

[Dale Howard [MVP]]

Erin --

How about by Project ID and then Task ID? Just a thought. If you need help
creating the SRS report, you may need to repost the question so everyone can
take a stab at it. Hope this helps.

 

[Erin]

Dale,

Thanks! I did this -- i'm running into an issue with the dates though. In
MS Project the application -- I use the columns labeled "Start" and "Finish"
-- this is where my PC's enter in the dates for the tasks -- when i ran a SRS
report - I took your suggestion of grouping by Proj ID then Task ID -- which
worked GREAT! then i used Task Start Date and Task Finish Date -- and these
do not match with the "Start" and "Finish" in the basic MS Project
application that's based off my enterprise template. I look at my project in
MS Project, write down teh start and finish date then go to MSP_TASKS and
look up the Proj ID and task ID and look for those dates and they are no
where -- is there another table these might be located in? I need to have
accurate dates for project metrics and I cna't think of any other table --

Thanks in advance and for all your help

(e-mail address removed)

-erin

 

[Dale Howard [MVP]]

Erin --

Are you publishing your project using File - Publish? That could account
for the difference between the project file dates and those you see in the
Reporting database. Let us know.

 

[Erin]

Dale,

Okay - here's what i've found so far....the dates i'm using are located in
the MSP_VIEW_PROJ_TASKS_STD -- then under the fields TaskStart and TaskFinish
-- this gave me the correct info -- however, when i run the report in VS.net
-- i get an error on memory running out to display it in layout -- it
displays it in the data tab with a right click - run -- but on preview tab it
errors out -- any ideas why?
Here's my query -- and then it's group'd by Proj ID then Task ID

SELECT dbo.MSP_TASKS.PROJ_ID, dbo.MSP_WEB_PROJECTS.PROJ_NAME,
dbo.MSP_TASKS.TASK_ID, dbo.MSP_TASKS.TASK_NAME,
dbo.MSP_VIEW_PROJ_TASKS_STD.TaskStart,
dbo.MSP_VIEW_PROJ_TASKS_STD.TaskFinish
FROM dbo.MSP_TASKS INNER JOIN
dbo.MSP_WEB_PROJECTS ON dbo.MSP_TASKS.PROJ_ID =
dbo.MSP_WEB_PROJECTS.WPROJ_ID INNER JOIN
dbo.MSP_VIEW_PROJ_TASKS_STD ON
dbo.MSP_WEB_PROJECTS.WPROJ_ID = dbo.MSP_VIEW_PROJ_TASKS_STD.WPROJ_ID
ORDER BY dbo.MSP_TASKS.PROJ_ID, dbo.MSP_TASKS.TASK_ID

 

[Dale Howard [MVP]]

Erin --

I'm not a DBA, so I'm not in much of a position to help you with this Query.
Please repost the question with the Query and let our DBA's take a stab at
it. Thanks.