Task_contact field in reporting database

[rohit barde]

Hi,
I need task_contact field in project 2007 reporting database. but it is not
there in reporting database, however it is there in published database under
msp_tasks table. please tell me how can i add this field in reporting
database so that it follows queuing and all procedure for RDS.

 

[Stephen Sanderlin]

Is this a custom field you've created?

--

Stephen Sanderlin

Principal Consultant

MSProjectExperts



For Project Server Consulting: http://www.msprojectexperts.com

For Project Server Training: http://www.projectservertraining.com



Read my blog at: http://www.projectserverhelp.com/

Join the community at: http://forums.epmfaq.com

 

[rohit barde]

Hi Stephen,
This is not custom field, it is msp field only but it is not in reporting
database. i think microsoft has taken commonly used fields in reporting
database.Please tell me where i need to change if i want to take this field
in reporting database also.

 

[rohit barde]

There is another field task_constraint_type which is default msp field in
MSP_Tasks table.this field is also not there in reporting database. i want
these all fields for reporting in reporting database.

 

[Stephen Sanderlin]

Okay. So, in this situation, the only thing I can suggest is to create a
custom table in the RDB and populate it with data you retrieve from the
PSI.

--

Stephen Sanderlin

Principal Consultant

MSProjectExperts



For Project Server Consulting: http://www.msprojectexperts.com

For Project Server Training: http://www.projectservertraining.com



Read my blog at: http://www.projectserverhelp.com/

Join the community at: http://forums.epmfaq.com

 

[rohit barde]

Hi Stephen,
Thanks for your reply.
Now i want to know how can i manage this data transfer in sync with the
deault RDB events?.if i write custom table i want to populate it same time
when related data is getting transferred in RDB through project server.

 

[Stephen Sanderlin]

These should help:



http://blogs.msdn.com/project_progr...tensions-local-custom-fields-custom-code.aspx

http://msdn.microsoft.com/en-us/library/aa494918.aspx


--

Stephen Sanderlin

Principal Consultant

MSProjectExperts



For Project Server Consulting: http://www.msprojectexperts.com

For Project Server Training: http://www.projectservertraining.com



Read my blog at: http://www.projectserverhelp.com/

Join the community at: http://forums.epmfaq.com