Hi,
I am doing a summary report of projects and need some help figuring out the best way to do it.
I have used mail merge with regions with no problems in the past but in this situation i need to have a repeatable region (Milestones) within an outer repeatable region(projects).
i.e. i want to display all milestones for a project as well as displaying all projects in the system (hopefully the attached word doc will make things clear).
To make things more complex i have to display the project name as a vertical merged cell that spans the number of associated milestones.
I can repeat the milstones no problems for an individual project (using mail merge with regions) but how do i then repeat this for each project?
Any ideas would be greatly appreciated, Thanks.