Showing related tasks in a task report

[thbrandtSU]

We have a Project with a section of Events our photo and video teams will be shooting at and a section of the finished deliverables that need to come from those Event shoots.

Project

- Events

-- Event A

-- Event B

- Production Work

-- Deliverable 1

-- Deliverable 2

-- Deliverable 3

-- Deliverable 4

I am trying to show the relationship in the report. Something like:

Event name	Event Details	Shot lists	Associated Deliverables
Event A	Date, Time	Shoot stuff	Deliverable 2 Deliverable 3 Deliverable 4
Event B	Date, Time	Shoot stuff	Deliverable 1

I assume we will need to relate tasks via a Custom Field. I was trying to add a field to a form at the Deliverable task with the URL/ID/Name of the Event it is associated with. Then in the report, I was using the listmethod :

valueexpression=IF({DE:Associated Event}=???,{name},"")
listdelimiter=<p>
listmethod=nested(project.tasks).lists
valueformat=HTML
displayname=Deliverable
type=iterate

I do not think I can pass in the context of the Event Task row in the report, though.

I think the logic needs to be : valueexpression=IF({DE:Associated Event}={Task Row ID/Name} , {Task Name of the DE:Associated Event} ,"")

1) Is this possible without Fusion? We do have it, so I can go that route if needed, but was trying to keep at a report level.

2) Is there way to use the row Name/ID as a contextual queue for an expression?

Thanks in advance.

[skyehansen · Accepted solution]

If I'm reading this correctly, you're right. There's no way to pass a variable into the "???" portion of your valueexpression. You would be much better off just making a deliverables report (i.e. task report filtering ONLY deliverables) and grouping by deliverable name plus a FEW details.