Enter Different values in Project Server and get in Reporting

[Sam]

I want to know actually I will create a report in reporting tool.
I want to enter different values which may be numeric and text and may be
select from drop down list which i will enter in my project at project
professional .
and when the report will be create in reporting tool.

the values which i entered in my project may be in project information
dialog box and other way will be display at report.

my first question is

How I can enter different values which for my project in project professional.
and these values will be at published database or in reporting database or I
need to create some fields in any database.

and then how to i get in reporting.

Kindly tell me solution.

 

[Andrew Lavinsky]

If I understand your question, you'd like to create Project Level Enterprise
Custom Fields, and then have those populate in the Reporting Database?

1) Within PWA, go to Server Settings > Manage Custom Fields
2) Create a new lookup table. Add data to the table.
3) Create a new field. Set it to the Project Level. Set it to Text or Number
as appropriate, and point it to the Lookup Table just created.
4) Close out of any open Microsoft Project windows. Open Microsoft Project
connected to the server.
5) Go to the Project Information dialog box and populate the appropriate
data.
6) Save and publish the data.

Your reporting database should now include the specific project level field
just created.

- Andrew Lavinsky
Blog: http://blogs.catapultsystems.com/epm

 

[Sam]

Kindly tell me in which table of reporting database the enterprise level
projects customize fields will create . if we create from Manage Custom
Fields .
and also in which table of Reporting Database the local project level
customize fields will exist.

 

[Rod Gill]

Hi,

Easiest place to see Custom data in project server is the Views in the
reporting db whose names end with _Userview. All custom fields are
automatically appended to them and they are updated whenever the project is
published.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com

Kindly tell me in which table of reporting database the enterprise level
projects customize fields will create . if we create from Manage Custom
Fields .
and also in which table of Reporting Database the local project level
customize fields will exist.



__________ Information from ESET Smart Security, version of virus
signature database 5118 (20100516) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5118 (20100516) __________

The message was checked by ESET Smart Security.

http://www.eset.com