Showing related tasks in a task report
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.