Report Integration for SQL Server 2012 and SharePoint 2010 was described comprehensively in my latest book:
The new features Power View and Data Alerts were treated in two complete chapters:
Chapter 6: Power View and Reporting Services
Six hands-on exercises
Chapter 7: Self service Data Alerts in SSRS 2012
Three hands-on exercises
The SharePoint 2010 used in the book should work equally well with SQL Server 2014 CTP2.
SQL Server 2014 CTP1 installation was described here.
Programs have been updated and new versions have appeared.
SQL Server 2014 is now in CTP2
Now how does one start working with features like Power View and Data Alerts?
You need to install and work with recent versions.
You need the following :
Microsoft® SQL Server® 2014 Reporting Services Add-in for Microsoft SharePoint®, Community Technology Preview 2 (CTP2)
You can download the above from here:
Details from the above site are here:
· The SQL Server 2014 CTP2 Reporting Services Add-in for Microsoft SharePoint technologies deploys the Reporting Services user interface pages and features on a SharePoint web front-end server.
- The SQL Server 2014 CTP2 version of the Reporting Services add-in supports SharePoint 2010 and SharePoint 2013.
- To use connected mode features of Reporting Services with the 2014 CTP2 add-in, the report server version must also be 2014 CTP2 version.
- For more information on supported versions, see “Supported Combinations of SharePoint and Reporting Services Components”.
- For more information on Local mode and connected mode, see “Use Access Services with SQL Reporting Services”.
After you install the Reporting Services Add-in and configure your servers for integration, you can publish Reporting Services content to a SharePoint library and then view and manage those documents directly from a SharePoint site. The Reporting Services Add-in provides the following functionality:
- Power View, a feature of Microsoft SQL Server 2014 CTP2 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition, is an interactive data exploration, visualization, and presentation experience. It provides drag-and-drop ad hoc reporting for business users such as data analysts, business decision makers, and information workers. Power View reports are in a new file format, RDLX.
- Open reports in Report Builder from a SharePoint library, and save reports to SharePoint libraries.
- A Report Viewer Web Part, which provides report-viewing capability, export to multiple rendering formats, page navigation, search, print, and zoom.
- SharePoint web pages so that you can create subscriptions and schedules, and manage reports and data sources.
- Support for standard SharePoint Foundation 2010 and SharePoint Server 2010 features including document management, collaboration, security, and deployment with report server content types.
- The ability to add the Reporting Services Report Viewer Web Part to any page or dashboard on a SharePoint site and customize its appearance.
- The ability to use SharePoint permission levels and roles to control access to report server content. You can also use SharePoint forms authentication to support access over Internet connections.
- Reporting Services data alerts, a data-driven alerting solution for SharePoint Server 2010 Enterprise Edition that informs you about changes in report data that are of interest to you, and at a relevant time.