SpsDev.Com’s PowerJAX Web Part combines the power of SharePoint with the cool features of AJAX and Web 2.0.  It allows you to rollup content from lists across your SharePoint farm into a single consolidated view in your SharePoint site.  The data is retrieved using AJAX so you don't have to bog your server down with slow running web parts that have to wait to retrieve all of the list information before showing the page.  Instead users see the page right away and then the data is retrieved asynchronously from their browser.

The PowerJAX Web Part has a number of features designed to give you complete control over the data that's returned.  You can retrieve data from lists in the same site, the same site collection, a site in a different site collection, or even a site in a different web application.  Any data anywhere in your entire SharePoint farm can be retrieved with PowerJAX.  We include an easy to use property page to find all of the lists in different sites, retrieve the fields for any list, and pick and choose which fields to display in the web part.  Even our property page is built on AJAX!  It's all been designed from the ground up to minimize disruptive post backs and the irritating screen flashing and refreshing that goes along with it. 

 We include a simple one-click verification process to ensure that all of the fields that have been selected are included in all of the lists you're getting data from.  As you add fields you can choose whether you want to include summary information for that field, such as a count of items, or the average or sum of that field's value.  We also allow you to apply filters and sorting based on the fields you are retrieving.  For example, only return data where the company name equals "Contoso", or where Fiscal Year is greater than 2006, etc.  If our filters are not sophisticated enough for your requirements, we even let you type in a custom query that conforms to the SPQuery specification for SharePoint.  That gives you the complete flexibility to control what data is shown in the web part.

The picture on the left shows what the property page looks like for selecting fields and applying filters; the picture on the right shows the property page where you select fields, create filters, and choose your sorting option.

PowerJAX also has a number of properties to control how data is displayed on the page.  For example, you can choose to whether to use a custom style sheet, so you can control the look and feel of the data that's displayed.  You can choose whether or not to show subtotals for each list, like a count, sum or average of a field.  You can choose to show ONLY the list totals.  You can control how many rows of data are returned, whether to show grand totals, whether to format the data, and more.

Here are some examples of some different views of data rendered with the PowerJAX Web Part:

This shows data sorted by Fiscal Year, using an average and sum total fields, with subtotals displayed for each list as well as a grand total for the entire list.

This shows the same data, but sorted by Proposal.  Also notice that all of the data in the second ("Euro Sales") list is collapsed, so you only see the totals for that list.

This shows all of the data details collapsed, and only list totals and the grand total displayed.

The picture on the left shows what the page looks like for the end user while the data is being returned from each SharePoint list. The picture on the right shows the list with no totals for each list, but a grand total displayed that has the count of all the items that were returned.

The picture below shows two PowerJAX web parts on the same page, side by side, rendering data from different sites and lists all on the same page.