Clickable link to Project data in a Task report

[William--]

In a Project report, the below effectively displays a friendly hyperlink to the Issues tab of the project. (The custom field being referenced is the URL of the project's Issues tab) displayname=Project Issues link.url=customDataLabelsAsString(URL - Issues Tab) textmode=true valueexpression=IF(ISBLANK({DE:URL - Issues Tab}),"","Project Issues") valueformat=HTML I have a Task report in which I need to achieve the same thing - a friendly hyperlink that launches the Issues tab of the project to which the task belongs. But, I'm not able to get the above code to point upwards to the project level. Any ideas on what the correct modification is? Seems like it should be possible. William English T-Mobile

[TealeMcCleaf]

Hi William, I accomplish this by creating a calculated field at the task level with this code: CONCAT("https://yourinstance.workfront.com","/","project/view?ID=",ID,"&activeTab=tab-project-optasks") Then I create a project level report that includes this field as a column and switch to text mode and input the following: displayname=Project Issues link.url=customDataLabelsAsString(Issues URL) linkedname=direct namekey=name querysort=DE:Issues URL textmode=true valueexpression=STRING("View Project Issues") valuefield=Issues URL valueformat=customDataLabelsAsString Hope this helps, Teale Teale McCleaf Google Inc.

[William--]

Thanks Teale, but that's not really my challenge - it's no problem to enable the link when I'm not spanning different object levels (like referencing the project's issues tab from a project report). What I need to do is provide a hyperlink to the project's issues tab from a task report. I couldn't get a link to display in the task report that pulls the URL from the custom form attached at the project level. I eventually gave up on this approach, and settled on attaching the custom field at the task level (which I was hoping to avoid). With the project's issues tab URL recorded on a custom form attached to every task being reported, it works as documented in the support article . It just doesn't seem like the procedure described there can be modified to to work if you are jumping object levels. William English T-Mobile