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.
http://hodentekmsss.blogspot.com/2013/09/installing-sql-server-2014-ctp1-on.html
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:
http://www.microsoft.com/en-us/download/details.aspx?id=40738
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.
