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
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
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
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
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
Views
Replies
Total Likes
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
That's what it was. I had {task} on the CONCAT line too. That worked, Thanks!
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
Views
Likes
Replies