Portal Solutions has extended Microsoft SharePoint 2007’s Data View part to allow for advanced joining and aggregation of data. The data sources can be configured with SQL like syntax to UNION and a INNER and outer JOIN different lists in different sites. The aggregated result set can be grouped, filtered and sorted by the user. Result presentation is managed by XSLT and supports all features of the standard Data View webpart, including SharePoint Designer support. Solution includes several webparts and data sources that can be used interchangeably.

Features
  • Support for joining multiple lists (inner, left/right outer)
  • Support for export to Microsoft Excel (can be provided from separate, connectable part)
  • Support for comparing user account against user lookup in a list being queried
  • Support for querying SQL Database for increased performance
  • Support for layering or joining through union different lists with “like” fields. Results would be stacked as if coming from the same list
  • Support for querying lists from a different site collection
  • Full support for XSLT
  • Support for working with lists from different site collections and web applications
  • Full support for EXSLT and MVP.XML functions
  • Support for acquiring the parent site name in the results of a list query


Quick Install Guide
  1. Install and deploy PS.WebParts.Rollup.wsp solution to desired web application
  2. Activate "Rollup Web Parts (PS)" Site Collection feature
  3. New webparts will be available under "Portal Solutions Web Parts"

Basic Usage
  1. Add "Rollup Content Data View" webpart to the page. This is the preferred webpart for aggregating data. If necessary, XSLT can be modified in SharePoint Designer to customize the presentation. WebPart is based on standard DataForm webpart and supports the native SharePoint Designer editing capabilities (managing columns, group by, filtering, etc).
  2. By default when webpart is added to the page it uses CrossSiteDataSource and is configured to retrieve all list items of content type "Item". "DataSource Editor" button allows you to configure datasource properties as well as use other data sources.
  3. "XSL Editor" displays current XSL template that controls presentation. Use SharePoint Designer to implement more advanced presentation.
  4. Check "Debug" box to output raw XML and other statistics to aid in troubleshooting issues.
  5. Example below shows basic data source configuration that retrieves all list items in the site collection with the title of "test". (see documentation on invididual datasources for detailed configuration)
<cc1:CrossSiteDataSource runat="server" ContentType="Item" TopLevelSite="/" Scope="Recursive" Lists="100" QueryRowLimit="100" ID="DSC">
<Fields>
<FieldRef Name="Title" /></Fields>
<Query>
<Where><Eq><FieldRef Name="Title"/><Value Type="Text">test</Value></Eq></Where>
</Query>
</cc1:CrossSiteDataSource>

Last edited Dec 9, 2011 at 7:44 AM by epranav, version 8

Comments

arindam_chat May 4, 2012 at 1:16 PM 
Is this one only for Sharepoint 2010? When I tried to install in Sharepoint 2007 it gives error like below :

Solution manifest for solution 'e92310dd-f01d-44cf-ab99-b03afd940092' failed val
idation, file manifest.xml, line 3, character 61: The 'Title' attribute is not d
eclared.
D:\Codeplex\PS.WebParts.Rollup.wsp: The Solution installation failed.