Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

We are designing a system with a national level, regional level and a sub-regional level.

We plan to implement this with a site structure with sub-sites and sub-sub-sites.

The sites at the lowest level will have a list.

One the level above we would like to have a list that contained all items from all subsites.

Is this possible without copying the list items?

share|improve this question
add comment

1 Answer 1

up vote 10 down vote accepted

Yes this can be achieved by using an SPSiteDataQuery. See: http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spsitedataquery.aspx. This will require some programming.

If you do not want to develop against the SharePoint Object model, then use the Content Query Webpart (requires SharePoint Publishing Infrastructure feature activated). You will need to modify some XSLT in this scenario.

Another way is to use the DataView webpart and set scope to recursive. See: http://sympmarc.com/2008/02/19/rolling-up-content-in-sharepoint-using-the-data-view-web-part-dvwp/. This can be done from SharePoint Designer.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.