Integrating custom reports with project server

A

Abhijeet

We have a requirement for creating status reports with project,
resource and custom fields data arranged in various formats. We are
inclining for creating custom reports using ASP and PDS calls.

How do we integrate the reports with Project Server? We want reports
to be associate the reports with groups.

Ideas are appreciated.
 
D

Dilanka

H

I am faced with a similar problem with the project Server. We use MS project Server 2002. MS project professional 2002 and MS Web access for project management. The concept is to drive every project through the project programme. each project manager will enter status (say weekly) in MS Web Access and then all project data will be in the MS project server. However we have a problem in capturing data entered via MS web access. our aim is to run an ODBC query and prepare a status report

1) We first thought we could do it by generating a status report for each project and then consolidate them to a master report. But apparently Status report is something not tied to any particular project but is something that gives a summary of status spanning each tem members work. We found all entries in MSP WEB Status report responses table in the Server 2002 and the problem is all entries are logged in one single data field called WRESP-TEXT field. Seperating them out is a whole different ball game and we still could not figure out how. Apparently you need an XML parser to do a job and that means spending additional money

2) the second option seems workable. We (our administrator) created custom fields in the Projects page of MS Web Access. If you click Edit Project details this prage allow you to enter customised data for each project. These customised fields can be saved in the Web Access but could not find the web table in the Server where these custom fields get saved to. There is a seperate Table (MSP VIEW PROJ Project ENT ) which get populated by these customised field but you have to open and save the MS project plan every time you enter project details, which we found a quite a hazzle specially when a project manager is dealing with 20 projects. Unless the MS Project plan is opened and saved these fields wont go in to the VIEW table. These customised fields you can see in the project plan if you go to >>>Project >>>Project Informatio

So if you have tried any of the above stuff and made any progress I like to hear from you or contact me by email

cheer

Dilanka
 
Top