View Column showing parent tasks only as list

[Tom2600]

On a Report View Column I only want to show the parent task name and not every single subtask how do I write that?
listmethod=nested(tasks,indent).lists. (WRONG)

displayname=Project Tasks Names
listdelimiter=<p>
listmethod=nested(tasks).lists.  (WORKS FINE)
textmode=true
type=iterate
valuefield=name
valueformat=HTML

[William-- · Accepted solution]

You need to replace valuefield with a valueexpression that will only list parent tasks.

displayname=Parent Tasks
listdelimiter=<div>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF({numberOfChildren}>0,{name},"")
valueformat=HTML

[Tom2600]

Thank you,  that somewhat worked BUT if I have a project that has 3 tasks & 2 without any subtasks then it returns null fro 5 &6?
(5 & 6) are Parent Tasks without any subtasks

[William--]

If you want to list parent tasks as well as tasks without children, this will work:

displayname=Parent Tasks
listdelimiter=<div>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression=IF(ISBLANK({parentID}),{name},"")
valueformat=HTML

[Tom2600]

THANK YOU!!! This is exactly what I needed to show!

[Tom2600]

If I wanted to create a report that shows these groupings

Portfolio name

Program name

Project name

And these Columns shown...

Task name

Assignment(s)

Due on

Do I need to write this in Text Mode only or are they OOTB in lookups?

[William--]

It depends on what kind of report you are making. 

It looks like a Task report. If so, everything you've listed can be done out of the box. If this task report is meant only for parent tasks as mentioned in the earlier thread, you can include "Task >> Parent ID = is blank" in your filter rule.

[Tom2600]

Thanks, where I am having the issue is Filtering and showing all tasks INCLUDING Parent > Sub Parent > Sub Sub Parent > Task 

I want to show all 4 levels in my report, I tried txt below in bold but the parents still don't show.

groupID=6351714c00134bd9cdf6464d54f185fb
groupID_Mod=in
parentID_Mod=notblank
numberOfChildren=0
numberOfChildren_Mod=eq
plannedStartDate=$$TODAY
plannedStartDate_Mod=between
plannedStartDate_Range=$$TODAYb+2w
project:name=QUE
project:name_Mod=cinotcontains

[Tom2600]

I also need to figure out how to show any task that should be worked on (based on planned start date and duration) and future task that are 2 weeks out.

SORRY I know alot of questions here!