Custom Task Field Value Not Show In Report

Question

I created a custom "Plan %" field, and I would like to show the overall "Plan %" for my subcontractor "Elite Comfort" in my report. The "Plan %" is able to roll up to summary task in Gantt Chart View, but when I go to Report>Project Overview, the overall "Plan %" is not showing anything for "Elite Comfort". Any idea what is the issue here?

Below is the link to the project file:
https://drive.google.com/file/d/1z3HLTvMHLcbJfsmJQqiAnd0XyR5VT-r6/view?usp=sharing

Best regards,
Tony

john-project · Answer

Tony_Cheah&nbsp;Did you customize the report format to include the field you are using for your "planned %"? What field are you using?&nbsp;I tried opening the attachment and nothing appears although I do see the file name says it is a "master". Are you working with a dynamic master file (I.e. file with inserted subprojects)?&nbsp;For reference, I have a dynamic master file and included the Text2 field to the Gantt Chart view. I then opened the Project Overview Report and edited it to include the Text2 field. This is what I get:John

tony_cheah · Answer

Hi&nbsp;John-project&nbsp;,&nbsp;Below is the Gantt Chart View of the file which include customize "Plan %":&nbsp;The "Plan %" formula I use is as per below:&nbsp;And under report, I would like to show the summary value of "Plan %"&nbsp; for "Elite Comfort", which currently is not showing any value.I think you will need to download the file in order to view it because currently google chrome dont have an extension that can open ms project file.&nbsp;Hope you able to help me on this.&nbsp;Thanks &amp; Regards,Tony&nbsp;

john-project · Answer

Tony,Your screen shots are helpful and unfortunately do not provide all the information I need to help you. For example, I don't know what your field list settings are for the Project Overview report. The "Late tasks" table on the report shows a single line of a task with the Elite Comfort resource but that doesn't match up with any task line shown in the screen shot of your Gantt Chart. I do see you have selected the Text1 field but there is no information about filter, group, outline level, or sort, which are all part of the field list selections.I cannot download your file because it is a view file only, not the actual Project file (i.e. .MPP). However you can send the file to me at the address below. I will ask some questions.Johnjmacprojataticlouddotdotcom(remove obvious redundancies)

tony_cheah · Answer

Hi John,&nbsp;The "Late tasks" table on the report shows a single line of a task with the Elite Comfort resource only because I'm trying to show a summary view of Elite Comfort current work status.&nbsp;I had send the file to your email, but not sure if I send to the correct email.Let me know if still havent received.&nbsp;I had change the setting of the file in my share drive to be able to edit by anyone with a link. So maybe you can try the link again also if the file was not send to your email.&nbsp;Thanks &amp; regards,Tony

john-project · Answer

Tony_Cheah,Sorry, I did not get an e-mail from you and I still cannot download from the link you provided. However, I think I may have figured out what's wrong. Please show a screen shot of the Field List for the Project Overview report.&nbsp;I'm guessing you have selected fields for "Resources" instead of fields for "Tasks". If so, then that's why you won't see any values for the Text1 field. The Task Text1 field is NOT the same field as the Resource Text1 field. Please refer to the following Wiki article:https://social.technet.microsoft.com/wiki/contents/articles/32051.ms-project-extra-fields-in-views.aspx&nbsp;&nbsp;If that does not directly answer your question, then please try sending me the file again. Read the encoded e-mail address I provided carefully.&nbsp;John

Forum Discussion

Custom Task Field Value Not Show In Report

Share

Resources