List predecessor and successor task in an assignment report? | Community
Skip to main content
RandyRoberts
New Participant
Jul 13, 2021 11:27 PM UTC
Solved

List predecessor and successor task in an assignment report?

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.
skyehansen
skyehansenAccepted solution
Level 4
Jul 14, 2021 12:48 AM UTC

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

5 replies

RandyRoberts
New Participant
Jul 13, 2021 11:41 PM UTC

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

Translate
skyehansen
skyehansenAccepted solution
Level 4
Jul 14, 2021 12:48 AM UTC

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

Translate
RandyRoberts
New Participant
Jul 14, 2021 1:46 AM UTC

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

Translate
skyehansen
Level 4
Jul 13, 2021 11:37 PM UTC

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

Translate