Grand Parent or Parent's Parent Task to show in own column on a Report

[MCriscella23]

Spoiler

Hi All! Hoping someone can help me figure out the right Text Mode configuration to pull in a task's Grand Parent name into it's own separate column. Within our projects many tasks have overarching Grand Parent tasks, then a Parent task, then a specific task assigned to a user. What I need is a way to include what that Grand Parent task name is on an Hour Report.

I figured out how to group by this information, but the particular report I am working on currently needs to have this information in a separate column. 

Any ideas on this would be really appreciated!!

[KristenS_WF]

See if this works for you.

displayname=Grandparent Task Name
textmode=true
valueexpression={parent}.{parent}.{name}
valueformat=HTML

[MCriscella23]

No, unfortunately it didn't work. Thank you so much though for replying!

[KristenS_WF]

This is what I get using that code (screenshots of test project and report results).

[MCriscella23]

I think it may be because it's on an Hour report, and not a Task report as I previously said (my mistake!). I'm working on a report someone else created, but if I can't get it to work on the hour report I may just create a new report as a better work around. Thanks again!

[skyehansen · Accepted solution]

try this:

displayname=grandparent
linkedname=task
namekey=view.relatedcolumn
namekeyargkey.0=task
namekeyargkey.1=parent:parent:name
querysort=task:parent:parent:name
textmode=true
valuefield=task:parent:parent:name
valueformat=HTML

All I do is take the Task | ParentID field from standard mode, change this to text mode, and change out the "ID" part for ":parent:name"

[MCriscella23]

That did it! Thank you so much for all your help, everyone!