How to Display time period totals on timesheet? RRS feed

  • Question

  • We need to submit our contractors hours to the budgeting department each week and they need to know each employee's total actual hours for the week.  We just upgraded to Project Server 2010 from 2003 and we can't find the setting to display the time period total when exporting a timesheet.  This value was present in 2003.

    We are using the export to excel feature.  Is there anyway to get the time period total to display on the timesheet?
    We are tracking actual hours and we are using the single entry mode.

    Thank you,

    Wednesday, May 9, 2012 5:08 PM

All replies

  • Did you consider using the "Timesheet Actuals" report under Business Intelligence >> Sample Reports?

    If that solution is OK with you, it is not too difficult to build a similar excel report to add any additional data you might need.

    Prasanna Adavi, PMP, MCTS

    Thursday, May 10, 2012 5:00 PM
  • Can non admins run these reports?  We rely on each individual contractor to put in their hours and then export to excel when they are ready.  They print the excel report and give it to a manager who then forwards it upstairs to the accounting and budgeting people.



    Thursday, May 10, 2012 8:30 PM
  • hi trent,

    These reports can run also non admins. users must have allowed in global permission "View OLAP data" and "View Business Intelligence Link"


    Thursday, May 10, 2012 8:48 PM
  • Yes, as Tomas confirms below, non-admins can run these reports. In fact in my opinion, this is much better than users sending separate excel sheets individually. Using the report you could look all resources in one single view.

    Prasanna Adavi, PMP, MCTS

    Thursday, May 10, 2012 9:03 PM
  • We have been messing with the Timesheet actuals report but it isn't giving us what we need.  We need to see hours worked per day (per task) and a total for the week for each person.  Is there a simple way to modify the report to show these fields?


    Tuesday, May 15, 2012 3:55 PM
  • TrentK,

    In that case, you will need to build your own report, but thats pretty easy. Navigate to the BICenter >> Templates >> "your Cube files" folder, and select OLAP Timesheet.

    This will open in excel and now you are able to drag and drop the fields you require as pivot table. Use the TIME Dimesion which will allow you to drill down to the day level.

    If you need more sophistication, it will require writing a query, that will match your needs.

    Prasanna Adavi, PMP, MCTS

    Tuesday, May 15, 2012 5:32 PM