Anyone know if there is a way to pull Task Specific info into a Project Report?

[MariaCr2]

Hi all - 

I want to know if there is a way to pull task info into a Project report? For instance, if I need a column on a Project report to show the Due Date of a specific Task, if there a way to pull that into a column? 

Thanks!

[KellieGardner · Accepted solution]

You can do this through a combination of collections and value expressions.

Reference collections in a report | Adobe Workfront

standard collection code:

valueformat=HTML
textmode=true
type=iterate
listdelimiter=<p>
displayname=Column Name
listmethod=nested(collection object name).lists
valuefield=collection object field

Combine collections and value expressions. Below is an example of how you could get your task data to populate into a column

valueformat=HTML
textmode=true
type=iterate
listdelimiter=<p>
displayname=Task XYZ Due Date
listmethod=nested(tasks).lists
valueexpression=IF({name}=xyz,{plannedCompletionDate})