View or report to see the Status manager value of different tasks

[Chris C]

We have been using PS 2007 for about a year.

Does anyone know how to pull a report or view that will list all the tasks
with the assocaited status manager value ? I am not lokking on a project per
project basis, but for all project in the database.

Thank you

Chris

 

[Jonathan Sofer [MVP]]

You'll probably need to run some kind of report off the Reporting Database
using SQL Server Reporting Services.

 

[Chris C]

Tx Jonathan.

I looked in the cube but this field is not available in any of them.

Chris

 

[Jonathan Sofer [MVP]]

I would always first recommend looking the cubes because that is where you
ideally would want to do cross project/resource reporting. I had a feeling
that "Status Manager" would not exist in the cubes.

If the field you require does not exist in the cubes (like "Status Manager")
then your next best option is to create some custom SSRS reports that read
directly from the databases.

 

[Mike Glen]

Hi Chris,

Next time, try posting on the microsoft.public.project.server newsgroup.
Please see FAQ Item: 24. Project Newsgroups. FAQs, companion products and
other useful Project information can be seen at this web address:
http://project.mvps.org/faqs.htm

Mike Glen
Project MVP