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
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