Add a column to a project report with a value from a custom form attached to a task

Question

I found a few older threads about this, but the solutions didn't seem to work for me, so I'm hoping to get feedback on what I'm doing wrong. I'm trying to add a column to a project report that will pull in a value from a custom form field that is attached to a parent task within the project called "Link to Published Content." It's a free text field. The way the projects and the report are set up, there should only be one paren task with a value in that field per project. I tried adding the following in text mode for the column, but it's not returning any values, even where that field is not empty. I'm fairly new to text mode in reports, so I'd appreciate any feedback:

displayname=Link to published report
listdelimiter=<p>
listmethod=nested(tasks).lists
textmode=true
type=iterate
valueexpression={DE: Link to Published Content}
valuefield=name
valueformat=HTML

listmethod=nested(tasks).liststextmode=truetype=iteratevalueexpression={DE: Link to Published Content}valuefield=namevalueformat=HTML

skyehansen · Accepted Answer

I feel like there's a problem with your syntax in that you have a valuefield and valueexpression line both in your block of text mode. I'd probably experiment with taking out the valuefield line.

Stacey_Robertson · Answer

You would need to start with a task report and then pull in the project fields that you need.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded