Cumulative planned and actual work

A

Andrew Stokes

Hi

I would like to put together a report to display cumulative planned work
against cumulative actual work (timesheet records) as a line graph to show
whether a project is diverging from plan. I can easily show a graph
comparing week by week planned against actual but I am having trouble making
this cumulative over time showing the amounts of work stacking up as the
project proceeds.

I intend to display this data using SQL Reporting services or Office Web
Components so what I could do with some advice on is how to construct the SQL
query.

I'm using Project Server 2007

Thanks in advance

Andrew
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PS 2010 : Work planned vs. forecast 3
Timesheets and Actuals 3
Planned Work vs Work not matching, SP2 3
Why does actual work replace the planned in Microsoft Project 2007 5
PJS2003 - Save one plan as another and OLAP work values 0
Data Analysis not showing correct Actual Work 3
Planned vs. Actual Hours 2
Recommendation for multiple Admin Break Fix Plans 2007 1

Top