List predecessor and successor task in an assignment report? | Community
Skip to main content
RandyRoberts
Community Advisor
Community Advisor
July 13, 2021
Solved

List predecessor and successor task in an assignment report?

  • July 13, 2021
  • 2 replies
  • 1019 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by skyehansen

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

2 replies

skyehansen
Community Advisor
July 13, 2021

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
Community Advisor
Community Advisor
July 13, 2021

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
Community Advisor
skyehansenCommunity AdvisorAccepted solution
July 14, 2021

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
Community Advisor
Community Advisor
July 14, 2021

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