Hello We have installed MS Project server 2007 with Sql Server 2000 and published 3-4 reports. Now I want to generate burn report of all the employees who are involved in various project for each week. Is there this type of any report included? Or Do I need to create, if yes is there any place where I get the complete database schema of MS Project Server database in detail? Regards Ashish
Hi, Microsoft have said they will not release the schema of all dbs as they need to reserve the right to change it as needed. However they have published the schema of the Reporting db. All your queries should be against Reporting db tables and Views. The reporting db schema is included in the SDK here: http://www.microsoft.com/downloads/details.aspx?familyid=2672f6f9-7028-4b30-99a2-18cb1eed1abe&displaylang=en -- Rod Gill Project MVP NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com "Ashish kanoongo" wrote in message news:Oj3lV13VHHA.4188@TK2MSFTNGP06.phx.gbl... > Hello > > We have installed MS Project server 2007 with Sql Server 2000 and > published 3-4 reports. Now I want to generate burn report of all the > employees who are involved in various project for each week. > > Is there this type of any report included? Or Do I need to create, if yes > is there any place where I get the complete database schema of MS Project > Server database in detail? > > Regards > > Ashish >
