This page allows you to build a roll-up Web Part that displays items collected from multiple lists of the same type.
The file you'll download (.webpart extension) is a Data View Web Part. Make sure you pick the Web Part builder adapted to your version of SharePoint (2007 or 2010).
There are two ways you can use the .webpart file on your site:
- switch your Web page to edit mode and use the import option ("Upload a Web Part" option in SP 2010).
- upload the file to the Web Part gallery
Once you have included the Web Part to a SharePoint page, you can further customize it with SharePoint Designer. Alternately, without SharePoint Designer you can edit the .webpart file in a text editor like Notepad.
Querying a large amount of lists or items can have a significant performance impact and may return incomplete results. Please refer to the Microsoft documentation for more information on cross-list queries.