Reporting Database PWA

[carlos neto]

My Project Reporting


Does anyone know which tables and fields in the Reporting Database I would
use to extract the following data, this report is designed to provide a project management office (PMO) to summary of the current state of each project in Microsoft Office Project Server 2007


Projectname
charter
baselinestart
baselinefinish
Budgeted at Completion (BAC).
Date (month/day/year)
actual work
last published



Submitted via EggHeadCafe - Software Developer Portal of Choice
Get Silverlight 4 Installed: Tips and Tricks
http://www.eggheadcafe.com/tutorial...b-f54c56a64ed9/get-silverlight-4-install.aspx

 

[Rod Gill]

HI,

Charter is a custom field. DateLastPublished isn't in the Reporting
database. However, you can create LastPublished project custom field and
save the publish date either using PSI or VBA. You can get this date from
one of the other tables, but Microsoft does not support that and your code
might break after any Service Pack or even hotfix.

All the rest should be in the MSP_Project_Userview View in the reporting db.
All Views ending with _Userview all have the relevant custom fields appended
to them automatically.

--

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




in message

My Project Reporting


Does anyone know which tables and fields in the Reporting Database I would
use to extract the following data, this report is designed to provide a
project management office (PMO) to summary of the current state of each
project in Microsoft Office Project Server 2007


Projectname
charter
baselinestart
baselinefinish
Budgeted at Completion (BAC).
Date (month/day/year)
actual work
last published



Submitted via EggHeadCafe - Software Developer Portal of Choice
Get Silverlight 4 Installed: Tips and Tricks
http://www.eggheadcafe.com/tutorial...b-f54c56a64ed9/get-silverlight-4-install.aspx

__________ Information from ESET Smart Security, version of virus
signature database 5073 (20100429) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5073 (20100429) __________

The message was checked by ESET Smart Security.

http://www.eset.com