Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-02-2017, 03:06 PM
ebilbrough ebilbrough is offline Status Date in a Report Windows 7 32bit Status Date in a Report Office 2013
Novice
Status Date in a Report
 
Join Date: Nov 2015
Location: Austin, TX
Posts: 19
ebilbrough is on a distinguished road
Default Status Date in a Report

Hi,



I'm using a modified MS Project Report template and want to display the project Status Date field in the report but can't find it in the field list.

Am I overlooking something or need to create a formula to get this to dissplay?

Thanks.
Reply With Quote
  #2  
Old 03-04-2017, 08:56 AM
JulieS JulieS is offline Status Date in a Report Windows 10 Status Date in a Report Office 2016
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

I'm guessing you are using one of the dashboard reports? If so, use a spare Date field (Date1 for example), customize the field with the formula [Status Date]. Make sure the calculation rolls up to summary. Then create a table with one cell. Use Date1 for the field.
Reply With Quote
  #3  
Old 03-07-2017, 03:00 PM
ebilbrough ebilbrough is offline Status Date in a Report Windows 7 32bit Status Date in a Report Office 2013
Novice
Status Date in a Report
 
Join Date: Nov 2015
Location: Austin, TX
Posts: 19
ebilbrough is on a distinguished road
Default

Thanks Julie! Forgot to select the rollup.
Reply With Quote
  #4  
Old 03-09-2017, 09:45 AM
JulieS JulieS is offline Status Date in a Report Windows 10 Status Date in a Report Office 2016
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You're welcome and thanks for the feedback.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to modify send status report in tasks office 2010 jonyorker Outlook 0 03-03-2015 07:31 AM
Status Date in a Report adjusting remaining work per status date ketanco Project 1 03-16-2012 06:02 AM
Status Date in a Report Meaning of current date vs status date when saving baselines ketanco Project 1 02-08-2012 02:20 PM
updating status date and actual duration ketanco Project 5 01-27-2012 07:32 AM
Status Date in a Report MS Project Start Dates not matching the Status Date sjodom Project 3 12-04-2011 08:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:41 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft