Reporting over SharePoint lists using Microsoft SQL Server Reporting Services and Enesys RS Data Extension. Enesys RS Data Extension.
Reporting over SharePoint lists using Microsoft SQL Server Reporting Services and Enesys RS Data Extension
Enesys RS Data Extension is a Reporting Services Data Processing Extension that makes it possible to use all the power of Microsoft SQL Server Reporting Services over your SharePoint data.
With Enesys RS Data Extension query language based on XML, you can retrieve, merge, join and calculate data from any SharePoint list.
Besides making it possible to build live interactive reports, Enesys RS Data Extension is also the perfect solution for solving business problems, by integrating and computing data from multiple SharePoint lists, that would otherwise needs the development of custom applications.
This presentation explains how Enesys RS Data Extension works.
Report Manager Report Viewer
Programmatic Interfaces:XML Web Service and URL Access
Report Builder – Query generationDrill-through Report generation
(SQL, XML, Oracle, …)
Report Server Databases
A report relies on one or more Dataset and one or more Data Source.
We will explain those simple concepts to show how Enesys RS Data Extension works.
SQL, Oracle, OLE DB, ODBC, XML, …
A report relies on data identified by a Dataset.
A Dataset queries a Data source for retrieving data
A Data source retrieves the real data.
SharePoint data is not relational by nature. To overcome this limitation, Enesys RS Data Extension provides an XML based query language that will let you manipulate SharePoint data in a relational way.