[Project Report] How to list nested tasks in chronological order.
- August 12, 2021
- 1 reply
- 1029 views
Hi Folks,
I have created a project report that pulls in tasks (i.e. milestones: zero duration tasks with no sub tasks) and groups them based on based on Complete or Incomplete status but for the life of me I cannot figure out how to get them to list chronoligically. Can anyone help?
column.18.displayname=Column
column.18.sharecol=true
column.18.textmode=true
column.18.value=<br><br><b>Key Milestones (Incomplete)</b><br>
column.18.valueformat=HTML
column.19.displayname=Column
column.19.listdelimiter=<p>
column.19.listmethod=nested(tasks).lists
column.19.sharecol=true
column.19.textmode=true
column.19.type=iterate
column.19.valueexpression=IF({numberOfChildren}=0,IF({duration}=0,IF({percentComplete}<100,(CONCAT("‚óá ",{name}," (Due: ",{plannedCompletionDate},")",IF({condition}=0,'<b><font color=03a219> [Green]</font></b>',IF({condition}=1,'<b><font color=e19503> [Yellow]</font></b>',IF({condition}=2,'<b><font color=d30519> [Red]</font></b>',""))))))))
column.19.valueformat=HTML
column.20.displayname=Column
column.20.sharecol=true
column.20.textmode=true
column.20.value=<br><br><b>Key Milestones (Complete)</b><br>
column.20.valueformat=HTML
column.21.displayname=Column
column.21.listdelimiter=<p>
column.21.listmethod=nested(tasks).lists
column.21.sharecol=false
column.21.textmode=true
column.21.type=iterate
column.21.valueexpression=IF({numberOfChildren}=0,IF({duration}=0,IF({percentComplete}=100,(CONCAT("‚óÜ ",{name}," (Complete: ",{plannedCompletionDate},")")))))
column.21.valueformat=HTML
RE: Explanation of Column 19.valueexpression (The first part of the formula)
Task Identifier:
IF({numberOfChildren}=0, IF({duration}=0, IF({percentComplete}<100,
Task Attributes to Display:
(CONCAT("‚óá ",{name}," (Due: ",{plannedCompletionDate},")",
Task Attribute to Display based on condition.
IF({condition}=0,'<b><font color=03a219> [Green]</font></b>',
IF({condition}=1,'<b><font color=e19503> [Yellow]</font></b>',
IF({condition}=2,'<b><font color=d30519> [Red]</font></b>',""))))))))
Condition and Key
Green = 0
Yellow = 1
Red = 2
Any help appreciated. thanks!