MS Reporting

Microsoft Project
W
Will Green 👤 Member for 17 years 4 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 3 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 6 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 9 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 1 month
· 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

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts