MS Reporting

Microsoft Project
W
Will Green 👤 Member for 17 years 6 months
· Permalink

Hi Andrew,



You can also save upto ten baseline positions if you can’t save copies of your schedule for some reason e.g. if you have live links to other projects. As an added bonus your gantt chart will have lots of coloured lines for each of the baseline positions which will baffle with science anyone who does not know much about schedules e.g. the management team. It does come in handy for getting snapshots and identifying trends against your original baseline over time, and you would be able to show in a report just the columns from previous months where you have baselined if you wanted.



Regards,

Will.

D
Darren Kosa 👤 Member for 18 years 5 months
· Permalink

Hi Andrew,



Do you archive your project files??



If I want to run a report retrospectively, I’ll just use a file from that reporting period.



Regards,



Darren

T
Trevor Rabey 👤 Member for 20 years 7 months
· Permalink

Andrew,

You don’t need to re-set the computer.



Project, Project Information, set the Status Date.



After you set the Status Date to, say, some date a month ago, select all Tasks and hit the "Update As Scheduled" button on the Tracking Toolbar.

See the Tracking Table for % Complete for every Task.

Job done.



However,if you are going to look for the planned % Complete (as well as the planned everything else) for a month ago, you must use the plan that was the current plan on that date. You can’t use this week’s plan for the status of a month ago.



That’s one (more) reason why you should save a copy of the plan every day, rather than just overwriting it every day.

A
Andrew McGuigan 👤 Member for 17 years 10 months
· Permalink

Thanks Colin



However I am looking for a summary report page telling me % complete as of last month etc.



Oddly enough I think I have found the answer, by going back in time! Yes by altering the time clock on the PC back a month, then printing out a summary report!



Needs must



Thanks

Andrew

C
Colin Blair 👤 Member for 22 years 3 months
· Permalink

Andrew



I would filter the tasks that are in that time frame.

Project/filtered for /date range

Select dates



Then, under the print options - select the date range you require.



File / print (timescale)

select dates





Hope this helps



Colin

Featured Partner

Top Posters

Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts
Jeamiell Ostrovsky
2 posts

Our Partners

Have your logo here? Contact [email protected]