project 2007 projectserver_reporting

[Lizzie Beth]

When you create a project plan, you have the ability to insert text1 to
text30 for all tasks in the plan and enter specific data for each task. I am
looking at the userviews in the SQL Management Studio to see if can query and
display the task name and text10. I have also looked at the tables in the
reporting database though have not found anything yet. Does anyone know how
to query the reporting database to show the task name and text10?

Any assistance is knowing where the task text10 and other task fields can be
queried is greatly appreciated!

Regards,
Lizzie Beth

 

[HansH]

Local custom fields (like Text10) are not available in the reporting
database.
A better approach would be to create an enterprise custom field in PWA.
This field is available for all your projects and the data is available
in the reporting database (in the user views).

I hope this helps,
Hans

Projectopolis <http://msepm.hsquared.be>

 

[Lizzie Beth]

Hans,
This is great information to help with some revisions to our proc ess.
Thank you!
Lizzie Beth