The Standard Reports in Microsoft Project 2010

Reports are another thing that I would imagine Project Manager do not use very often in Microsoft Project, probably because they are not aware that they actually exist, or they are not sure how to use them. I am not going to be covering how to use these reports, rather I am going to list out the standard reports that exist to hopefully give some exposure to them.

Microsoft Project 2010 contains a number of standard text based and visual reports found on the Project Tab in the Reports Group. I’ll cover the visual reports in a later post.

image

Standard Reports included in Microsoft Project 2010 are:

  • Overview Reports
    1. Project Summary – displays high level information about your project including key dates, work, duration, costs, task and resource status.
    2. Top-Level Tasks – displays the summary tasks at the highest level in your project as of today’s date. You can also see the scheduled start and finish dates, % complete, cost and the work required to complete each task.
    3. Critical Tasks – displays the status of tasks on the critical path of your project. It also displays the planned duration, start and finish dates, resources, predecessors and successors for each task.
    4. Milestones – displays information about milestones listed within your project schedule. It also displays the planned duration, start and finish dates, resources and predecessors for each task.
    5. Working Days – displays the working days and time for your project based on the calendar working times, exceptions and exclusions.
  • Current Activity Reports
    1. Unstarted Tasks – displays duration, start and finish dates, predecessors and resource information for tasks that have not yet started, ordered by scheduled start date.
    2. Tasks Starting Soon – displays duration, start and finish dates, predecessors and resource information for tasks that are within the date range parameters, ordered by scheduled start date. Completed tasks are displayed in this report and highlighted with a tick.
    3. Tasks In Progress – displays duration, start and planned finish dates, predecessors and resource information for tasks that have started but not yet been marked as complete.
    4. Completed Tasks – displays the actual duration, actual start and finish dates, percent complete (which appears to always be 100%), the actual cost and actual work hours.
    5. Should Have Started Tasks – displays the planned start and finish dates, baseline start and finish dates, and variances for start and finish dates, and information about any successors. This information is based on a supplied date parameter.
      A project baseline is mandatory for this report to function due to planned dates coming from the project baseline.
    6. Slipping Tasks – displays tasks that have been rescheduled from their baseline start date.
      A project baseline is mandatory for this report to function due to planned dates coming from the project baseline.
  • Cost Reports
    1. Cash Flow – displays the costs for each task on a weekly basis in a tabular format. The time increments can be changed by editing the report definition.
    2. Budget – displays all tasks, their budgeted cost, actual cost, and the variance between the budgeted and actual costs.
    3. Over Budget Tasks – displays the baseline, cost, actual, variance, and remaining information about tasks that exceed their budgeted amounts.
      At least one task needs to be partially completed and resources need to be allocated with costs in order for this report to print.
    4. Over Budget Resources – displays the baseline, cost, actual, variance, and remaining information about resources whose costs will exceed baseline estimates.
      At least one task needs to be partially completed and resources need to be allocated with costs in order for this report to print.
    5. Earned Value – compares each tasks planned vs. actual costs and schedule against a project baseline.
      The acronyms used in this report are: 

      1. BCWS – Budgeted Cost of Work Scheduled
      2. BCWP – Budgeted Cost of Work Performed
      3. ACWP – Actual Cost of Work Performed
      4. SV – Schedule Variance
      5. CV – Cost Variance
      6. BAC – Budget At Completion
      7. EAC – Estimate at Completion
      8. VAC – Variance at Completion

      A project baseline is mandatory for this report to function due to all planned costs come from a project baseline.

  • Assignment Reports
    1. Who Does What – displays a list of resources, the tasks assigned to each, the amount of planned work and the planned start and finish dates.
    2. Who Does What When – displays a list of resources, the tasks assigned to each and focuses the attention on the daily work scheduled for each resource. The time increments can be changed by editing the report definition.
    3. To-do List – displays a list of the tasks assigned to resources on a weekly basis.
    4. Over Allocated Resources – displays a list of resources that have been over allocated, the tasks to which they have been assigned and the total hours of work assigned to them.
  • Workload
    1. Task Usage – displays a list of tasks, the resources assigned to each and the amount of work that’s assigned to each resource in weekly increments.
    2. Resource Usage – displays a list of resources, the tasks assigned to each and the amount of work that’s assigned to each resource in weekly increments.
  • Custom
    1. Base Calendar – similar to the Working Days report – displays the working days and time for your project based on the calendar working times, exceptions and exclusions.
    2. Budget Report – displays a list of tasks, their fixed costs, accrual methods, total costs, baseline costs, variance, actual and remaining costs.
    3. Cash Flow – displays a list of tasks and their expenditure in weekly increments.
    4. Completed Tasks – same as Completed Tasks above.
    5. Critical Tasks – same as Critical Tasks above.
    6. Crosstab – displays tasks, resource and time information in a crosstab format.
    7. Earned Value – same as Earned Value above.
    8. Milestones – same as Milestones above
    9. Over Allocated Resources – same as Over Allocated Resources above.
    10. Over Budget Resources – same as Over Budget Resources above.
    11. Over Budget Tasks – same as Over Budget Tasks above.
    12. Project Summary – same as Project Summary above.
    13. Resource – displays a list of resources and relevant information over two pages. The first page includes information such as the resource Id, indicator icons, name, type, initials, material label, group and maximum units. The second page includes information such as rate information, accrual information, calendar information and code information.
    14. Resource (material) – same as Resource above, filtered by resource type of material.
    15. Resource (work) – same as Resource above, filtered by resource type of work.
    16. Resources Usage – same as Resource Usage above.
    17. Resources Usage (material) – same as Resource Usage above, filtered by resource type of material.
    18. Resources Usage (work) – same as Resource Usage above, filtered by resource type of work.
    19. Should Have Started Tasks – same as Should Have Started Tasks above.
    20. Slipping Tasks – same as Slipping Tasks above.
    21. Task – displays a list of tasks with their Id, name, indicator icon, duration, planned start and finish dates, predecessors and resource names.
    22. Task Usage – same as Task Usage above.
    23. Tasks In Progress – same as Tasks In Progress above.
    24. Tasks Starting Soon – same as Tasks Starting Soon above.
    25. To-do List – same as To-do List above.
    26. Top Level Tasks – same as Top Level Tasks above.
    27. Unstarted Tasks – same as Unstarted Tasks above.
    28. Who Does What – same as Who Does What above.
    29. Who Does What When – same as Who Does What above.

Almost all the standard reports found in Microsoft Project 2010 are customisable. You are also able to create your own project reports reports from scratch, or you can start off by copying any of project’s existing custom reports.

There are 4 basic Project 2010 Report Formats that you can work with, they are:

  1. Task Report Format
  2. Resource Report Format
  3. Crosstab Report Format
  4. Calendar Report Format

Project 2010’s built in reports are pretty basic, so it shouldn’t take you to long to figure it out and get up and running.

4 thoughts on “The Standard Reports in Microsoft Project 2010

  1. we have recently started use of it, but unable to take out monthly and weekly reports, as used to take it in 2007 ver.
    pl help to sort out the same.

  2. where does the Report overview project summary infromation get pulled from?
    I use to be able to find it on the property tab but now I do not see that either.
    thanks,

  3. Good respond in return of this question with solid arguments and describing the whole thing regarding that.

  4. Can I have a report in a graphical format that gives me a plan vs. actual comparison of percentage of work completed on a week timescale i.e. on x axis I need weeks (week1, week2, week3, …week ‘n’) and on y axis I need % work completed. So effectively I will have 2 lines in the graph, one for plan and the other for actual…
    Is this achievable in MS Project 2010?

    Any suggestions will be helpful.
    Thanks in advance!

    SAM

Comments are closed.