Enesys RS Data Extension is a Reporting Services Data Processing Extension that makes it possible to use SharePoint lists data for building reports with Microsoft SQL Server 2005 Reporting Services.
With Enesys RS Data Extension
query language based on XML, you can retrieve data from any SharePoint list (document library and form library are considered lists as well) and use it for building reports. Enesys RS Data Extension
query language also features commands for joining and merging lists data before reporting on them.
Enesys RS Data Extension also provides features for retrieving list collection, list permissions, web permissions and SharePoint groups for a specific site or a set of sites.
Enesys RS Data Extension includes numerous features that will not only let you retrieve SharePoint data but solve business problems as well:
- Filtering list data
- Using report parameters
- Expanding recurring events
- Stripping Html tags
- Retrieving items and folders in a specific folder
- Expanding multiple Values
- Joining result sets
- Merging lists using a reference list
- Rolling up lists in a site collection
- List permissions
- Web permissions