List predecessor and successor task in an assignment report?

[RandyRoberts]

I'm trying to list task predecessor and assignedTo name, and successor task and assignedTo name for a given task in an assignment report. (not a task report)

I can get predecessor names in a task report using the following:

valueexpression=CONCAT({predecessor}.{name})

listdelimiter=<br>

listmethod=nested(predecessors).lists

valueformat=HTML

displayname=Predecessor Name

textmode=true

type=iterate

And predecessor assignee:

displayname=Predecessor Assignee

listdelimiter=<br>

listmethod=nested(predecessors).lists

textmode=true

type=iterate

valueexpression=CONCAT({predecessor}.{assignedTo}.{name})

valueformat=HTML

In an assignment report I would assume I could add "task" before predecessor but that doesn't work.

Like: valueexpression=CONCAT({task}.{predecessor}.{name})

The only other way I can think of is a task form with calc fields for previous tasks and next task and their assignees, then display that on an assignment report.

There has to be an easier way though. Thanks

[skyehansen]

it's pretty close. The only thing you need to change is your collection -- this should be task.predecessors rather than predecessors. e.g. listmethod=nested(task.predecessors).lists

[RandyRoberts]

So hopeful… but no go.

This is what I just tried:

valueexpression=CONCAT({task}.{predecessor}.{name})

listdelimiter=<br>

listmethod=nested(task.predecessors).lists

valueformat=HTML

displayname=Predecessor Name

textmode=true

type=iterate

[skyehansen · Accepted solution]

nothing additional is needed for your valueexpression lines. Those should have carried over as-is. The only add was the “task” on the collection line.

e.g.

displayname=Predecessor

listdelimiter=<br>

listmethod=nested(task.predecessors).lists

textmode=true

type=iterate

valueexpression=CONCAT({predecessor}.{name})

valueformat=HTML

[RandyRoberts]

That's what it was. I had {task} on the CONCAT line too. That worked, Thanks!

[jamesg8368739]

Working, but the Predecessor assignee is not including the team assignment. Our task includes a resource and a team. Any suggestions? Also, wondering how I could include the Iteration of the predecessor task. Any help appreciated.