Add Business Intelligence to your SharePoint lists

The increasing adoption of SharePoint as an intuitive collaboration platform for users has spread business data over multiple sites and lists. At the same time, this has created the need to report and aggregate data from multiple SharePoint sites and lists to further increase the business value of this data.

Enesys RS Data Extension provides a solution to this demand by extending "Microsoft Reporting Services" and by letting you query (retrieve, join, merge,...) data and build reports from any SharePoint lists.

Design your query using our Visual Query Designer

Enesys RS Data Extension lets you build sophisticated queries over your SharePoint lists by using a Visual Query Designer that is completely integrated into Business Intelligence Development Studio. It supports many features that will let you get the most of your SharePoint data.

Support for specific SharePoint features like folders, recurring events, meeting instances, multi-value columns
Support for single and multi-values report's parameters
Roll up list's items within an entire site collection

Build your report with Microsoft Report's designer

No need to learn a new tool. Build your report using Microsoft's Report Designer and take advantage of its numerous features.

Sophisticated layout that lets you build dashboard views easily
Report's expression and interactive features
Extensive 2D and 3D charts and gauges controls
Flexible export features: Word, PDF, XML,...

Share your report for immediate availability to all users

Once your report is ready, it is only one click away from being available to all users.

With Reporting Services installed in SharePoint Integration mode, your reports are directly available within your sites.

Besides making it possible to provide live reports to users, Enesys RS Data Extension is also the perfect solution for solving business problems, by integrating and computing data from multiple lists, that would otherwise need the development of custom applications.

Sample Reports Gallery

Click on a thumbnail to display the report. The complete set of reports built over Microsoft Sales Lead Pipeline site template is available for downloading and ready to use.

Try it now!

You don't need a report server installation in order to test Enesys RS Data Extension.

Microsoft's Report Designer installed on your workstation is all you need to build and preview reports. It can be installed from SQL Server Installation CD by selecting Business Intelligence Development Studio.

Once it is installed, run Enesys RS Data Extension installation program, run the client configuration tool and you are ready to build reports over your SharePoint lists.

See it in Action

The following screen cast will show you the basics of creating reports using data from SharePoint lists.

Focus

SharePoint InfoPath Forms

Enesys RS Data Extension specific support for InfoPath Form Libraries lets you select any field, including repeated items, in your InfoPath Form. Using this feature, you can display your form using multiple alternative layouts and, extend your InfoPath Form data analysis to a more detailed level.

This video shows you how to build a report that displays Sales by Product, using data from InfoPath forms used for Invoicing.

SharePoint Multi-Value Fields

Enesys RS Data Extension allows you to break down multi-value columns data into multiple single values. This approach lets you build reports that can display items grouped on any multi-value field as well as provide the necessary granularity to accomodate all kinds of calculation.

This video shows you how to build a report that takes advantage of this feature in order to group items based on a multi-value field.

Reporting Over Survey Lists

By using Enesys RS Data Extension 3.6 new features, you can build great looking reports from your SharePoint Survey lists.

Though you can build your very own reports, we are providing a Generic great looking report that can be used right out of the box on any survey list.

Ever wanted to send a survey result as a PDF document or have your survey report in a Word document so that you can add comments and annotations?

Testimonials

"We needed a way to take advantage of our data locked in SharePoint. Enesys RS Data Extension has been a fantastic product for us and has opened up a lot of new development in our SharePoint environment.

The software is easy to configure, easy to use, and sales and support at Enesys is great."

Micheal Goodwin
Information Technologies Administrator
Broussard & Company

News & Blog

Coming in ERSDE 3.9 – support for multi-value parameters in the query designer

Even though Enesys RS Data Extension queries support multi-value parameters (using “IN” clause either at the list level or within a SqlQuery statement), it was only possible to pass a single parameter values when executing the query (for testing purposes) within the query designer. ... (14/05/2013)

Coming in ERSDE 3.9 - send technical data and error log the easy way

Because Enesys RS Data Extension supports Reporting Services 2005, 2008, 2008R2 and 2012 as well as SharePoint 2007, 2010 and 2013, it’s always tricky for the support team to get the necessary customer configuration information without exchanging several emails.

... (10/05/2013)

Coming in ERSDE 3.9 - SharePoint 2013 compatibility

Enesys RS Data Extension is now compatible with SharePoint 2013.

... (09/05/2013)

Enesys RS Data Extension 3.8.125 released

Enesys RS Data Extension 3.8.111 is a maintenance release that fix the following bug: ... (09/05/2013)

More News