The first benefit of Enesys RS Data Extension is to make it possible to build reports over SharePoint lists data using all the features provided by Reporting Services.

You can use this report viewer web parts to display graphical representation of your data directly into your SharePoint pages.

It might be desirable for some specific lists to provide an access limited to some fields. For example, you might have a list of contacts whose "home phone numbers" should only be viewable by some authorized users. It's not currently possible to address this situation in SharePoint without duplicating the contact list.

Reports can be executed in the user security context of your choice. Thus you can restrict permissions on a SharePoint list and still provide specific views on that list using reports built with Enesys RS Data Extension.

Using the features of Enesys RS Data Extension, you can merge an unlimited number of SharePoint lists. One of the possible use of this feature is to merge contact lists from various sites and to export the merged data to excel for mail-merge purpose.
Using the appropriate url options, just one click on a link can build the report and export it automatically to excel.

By using Reporting Services subscription features, you can deliver reports based on SharePoint data through email on a regular schedule

Using the "union" operator, you can roll-up list items from various lists located in various sites into one view.

Even more easily, you can roll-up list items from multiple lists located in a site and its sub sites using a simple multiLists command, providing the lists have the same title.