Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!
SOLVED

tasl column in project report

Avatar

Level 1

Am I able to add a column to to a project report for tasks of the project?  If so, how do I do that?  I can't figure it out.

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hello Karen,

 

@Leigh_Hastyis completely right, starting from a task report would be the better way.

 

You are able to add a column with all project tasks into a project report, but there are some limitations:

The text mode should be like this:

valueformat=HTML
textmode=true
type=iterate
listdelimiter=<p>
displayname=Project Tasks Names
listmethod=nested(tasks).lists
valuefield=name


Using this, you will only see the task names as plain text and not be able to click on them.

 

Alternatively, you can use a workaround to get clickable links, but those will only be displayed as urls without having the possibility to show the task name only.

valueexpression=CONCAT({name}," - ","https://<instance>.my.workfront.com/task/",{ID})
listdelimiter=<br>
listmethod=nested(tasks).lists
valueformat=HTML
displayname=Project Tasks Names
textmode=true
type=iterate

 

 

Regards

Lars

View solution in original post

3 Replies

Avatar

Level 2

Hi Karen,

I'll let others experts comment on how to make that happen, but I'll say that it's always better to start with a task report and pull in project fields.  If you can recreate the report as a task report, I think you'll have less aggravation in the end.

Avatar

Level 1

Thanks.  I wondered if I would need to change it to a task report.  But I'll wait to see what others say.

Avatar

Correct answer by
Level 10

Hello Karen,

 

@Leigh_Hastyis completely right, starting from a task report would be the better way.

 

You are able to add a column with all project tasks into a project report, but there are some limitations:

The text mode should be like this:

valueformat=HTML
textmode=true
type=iterate
listdelimiter=<p>
displayname=Project Tasks Names
listmethod=nested(tasks).lists
valuefield=name


Using this, you will only see the task names as plain text and not be able to click on them.

 

Alternatively, you can use a workaround to get clickable links, but those will only be displayed as urls without having the possibility to show the task name only.

valueexpression=CONCAT({name}," - ","https://<instance>.my.workfront.com/task/",{ID})
listdelimiter=<br>
listmethod=nested(tasks).lists
valueformat=HTML
displayname=Project Tasks Names
textmode=true
type=iterate

 

 

Regards

Lars