This topic contains 4 replies, has 2 voices, and was last updated by Tom Boyle 2 weeks, 5 days ago.
- 06/25/2019 at 2:25 pm #415848
Does anyone know if you can include the project status date to a report in MsProject? This would be helpful information to be able to automatically include in a custom status report.
Thanks in advance.
David06/25/2019 at 3:24 pm #415849
David, best I can tell you in a quick look is to use a custom date field and have it equal to the Project Status date [Status Date]. Not sure you can retrieve it otherwise within Project. You can get it within Project Online or Project Server from the database.
Maybe someone has a shortcut. Hope that helps.06/25/2019 at 3:41 pm #415850
Thanks Larry. I will look at trying that. I already looked into Project Online, to see if there were any enterprise options.06/25/2019 at 4:18 pm #415851
If you want to show today’s date in the Gantt chart area, you can adjust the gridlines.
Right click on the Gantt Chart; select Gridlines -> Current Date06/25/2019 at 5:16 pm #415852
For “Visual Reports” (the pivot table/chart exports to Excel), then I think Larry’s already answered. You’ve got to get the status date into the task records through a custom field.
Inside MSProject, the Project Status Date is included among the “General:” fields that can added to Headers and Footers in the page setup dialog. That dialog is available for Reports as well as Views/layouts.