Hi Any one knows the query to retreive following data; Resource name, Resource Team Name, Project Name, Timesheet Period, Billable Hours, Non Billable Hours, Work Order Number (Custom field) Thanks In Advance ss028955
From Microsoft .com search for and download the schema for the Reporting database. Give this to your database administrator and they can help you create the View. The Views in the reporting db are very useful. For example MSP_EpmTask_UserView show most Task data and automatically has all custom fields added to the end of it (for your Work order Number). There are similar Userview Views for Projects, Resources and Assignments. -- Rod Gill Microsoft MVP for Project Author of the only book on Project VBA, see: http://www.projectvbabook.com "ss028955" wrote in message news:128BEE42-23A3-4AC4-95B7-6F0EE53F9C53@microsoft.com... > Hi > > Any one knows the query to retreive following data; > > Resource name, Resource Team Name, Project Name, Timesheet Period, > Billable > Hours, Non Billable Hours, Work Order Number (Custom field) > > Thanks In Advance > ss028955
