none
Export Administrative time with task assignement in the same Excel SpreadSheet RRS feed

  • Question

  • HI,

    We use Project Server to create and submit our timesheet to Human Resources. We currently use Project server 2003 with an administrative project containing all non project task, like vacation and personnal time. The tasks in this project are shown in the tasks assignement view, so we can export it to an Excel Spreadsheet, do some formatting and submit it to Human Resources. We would like to move to Project server 2007, but i can't found a way to do the same. Is there a way? Can we show the administrative time in the same view as tasks assignement to export it to excel? Is somenone out there using Project server 2007 to submit timesheet to another departement for pay or other use?

    Any hint welcome! Thank you!

    Pierre-Nicolas

    Tuesday, August 10, 2010 8:26 PM

Answers

  • Pierre-Nicolas --
     
    If you migrate to Project Server 2007, your organization will not longer need to use an administrative project.  Instead, you will be able to use Administrative time categories on the My Timesheet page to collect project work, non-project work such as meetings and training, and non-working time such as vacation and sick leave.  You will also be able to designate project work as Billable and Non-Billable as well.  Your Project Server administrator can report on the administrative time using a Portfolio Analyzer view, which can then be exported to Excel, or by creating a custom report using a tool such as SQL Reporting Services.  Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Wednesday, August 11, 2010 2:14 AM
    Moderator

All replies

  • Pierre-Nicolas --
     
    If you migrate to Project Server 2007, your organization will not longer need to use an administrative project.  Instead, you will be able to use Administrative time categories on the My Timesheet page to collect project work, non-project work such as meetings and training, and non-working time such as vacation and sick leave.  You will also be able to designate project work as Billable and Non-Billable as well.  Your Project Server administrator can report on the administrative time using a Portfolio Analyzer view, which can then be exported to Excel, or by creating a custom report using a tool such as SQL Reporting Services.  Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Wednesday, August 11, 2010 2:14 AM
    Moderator
  • Do you know of a template for SQL Report Server? I've found the Report Pack 2 for SQL Report Server, but it's not exactly what I want.

     

    Thank you!

     

    Pierre-Nicolas

    Wednesday, August 11, 2010 5:03 PM
  • Pierre-Nicolas --
     
    I am not a DBA, so I do not have a template for you.  You might ask this question as a new post in the newsgroup and see if anyone else can help you.

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Thursday, August 12, 2010 2:30 AM
    Moderator