Project Server 2007 and SSRS

[Poonam_YC]

Hi,

Is it possible to customise the pwa Status Reports so that it populates risks and issues for the respective project workspace.
Also is there a way to add a link in the project workspace instead of the Project web access home page, clicking of which generates the SSRS report for that particular site. How to pass the project name or id of a particular workspace to an SSRS report when the project workspace is opened.

Regards

[FlayoFish]

If you want to run the reports, get the sample databases used to build Them here: http://blogs.msdn.com/chrisfie/archive/2008/05/22/project-server-2007-sample-databases.aspx then you'll be Able to figure out the custom fields and lookup tables required. In Project Server 2007, custom views are created in the Reporting Database for All Custom Lookup Tables. So in this case, We have a LT Called Organization in the database.