I hope someone can help me figure this out. I have a set of Initiatives, each containing multiple projects, and each project containing multiple tasks. I have tables setup for initiatives, projects, and tasks. Right now, when you look at the Initiatives page there is a report showing the Initiative detail, another tabular report showing the the projects, and another tabular report showing all of the tasks HOWEVER it's showing all of the tasks associate with the initiative.
What my team would like to see if the Initiative details at the top of the page, then the details for a single project, then the tasks for that project.
Then below that, the details for the next project, and the tasks for that project.
The problem is that I never know how many projects there will be, so I don't know how many of the project reports or task reports I need to show. Can anyone help me figure this out?