locked
Reading Timesheet Data RRS feed

  • Question

  • Hi,

    I am working on Project Server 2010,How to read Timesheet of Resource Programatically and show it in Datagrid or Griedview in normal .aspx page and where can i find step by step to do the process as i am new to Project Server Coding

    Thank You

    Tuesday, March 15, 2011 8:44 AM

Answers

  • General rule of thumb:  If you want to Read data in project server - use the Reporting Database as your datasource.  If you want to modify data, use the web service.  There are exceptions, but in your case I would suggest your grid would have a dataset as its datasource - your dataset gets filled using ADO.NET objects that read from the reporting database.  Actual work is contained in the MSP_EPMAssignmentByDay_UserView view of the reporting database.  You can also read from one of the timesheet views - if thats indeed what you are after.

    John

    www.nclarity.net

     

     

    Wednesday, March 16, 2011 12:17 PM

All replies

  • What will this information be used for?  If this is for reporting - have a look in the SDK where there is the database schema - http://www.microsoft.com/downloads/en/details.aspx?FamilyID=46007f25-b44e-4aa6-80ff-9c0e75835ad9&displaylang=en

    This will give you guidance on how to query the reporting database to produce the SQL report to retrieve this information.

    Regards,

     


    Best Regards, Dharmesh Patel Microsoft Technology Specialist Project Server / SharePoint / BI Reporting http://www.DharmeshPatel.co.uk
    Tuesday, March 15, 2011 10:27 AM
  • Hi Dharm

    This is not for reporting,i have to show the timesheet data in frontend like Datagrid or Gridview control and i dont want the timesheet data from backend,i have to use PSI Webservice

    Thank You

    Tuesday, March 15, 2011 10:51 AM
  • General rule of thumb:  If you want to Read data in project server - use the Reporting Database as your datasource.  If you want to modify data, use the web service.  There are exceptions, but in your case I would suggest your grid would have a dataset as its datasource - your dataset gets filled using ADO.NET objects that read from the reporting database.  Actual work is contained in the MSP_EPMAssignmentByDay_UserView view of the reporting database.  You can also read from one of the timesheet views - if thats indeed what you are after.

    John

    www.nclarity.net

     

     

    Wednesday, March 16, 2011 12:17 PM