Our client, who runs a business that oversees a group of shops, would like to set up an intranet site, with this basic structure:
- A main landing/info site
- Child site for shop 1
- Child site for project 1
- Child site for project 2
- Child site for project n
- Child site for shop 2
- Child site for project 1
- Child site for project 2
- Child site for project n
- Child site for shop 1
Each "project" site will have its own task list and calendar.
The question is, he would like to have an "executive view" that would allow executives to see a "merged" master task list and calendar that would include all tasks and calendar events from all active projects, in a single view.
In SharePoint 2010, what is the easiest way to implement this? Are there third-party controls that already provide this type of rollup view?