Databases Reference
In-Depth Information
Summary
In this chapter, we looked at accessing Report Servers from three different kinds
of applications, namely, SSIS, WPF Application, and SharePoint Site. SQL Server
Integration Services can be used to look at Report Servers using the Web Service
Task but still some of the parts are hard to configure. The Windows Presentation
Foundation class project as well as the Windows Forms project can make use of
a Web Browser control to access Report Servers useful for developers desiring
to integrate reports with desktop/Web applications. Finally, reports on a Native
mode Report Server can be brought into folder, traversed and viewed by using
SharePoint Web parts, the Report Explorer, and the Report Viewer.
While SQL Server 2012 marked the beginning of Reporting Services 2012 integration
with SharePoint 2010, there are still many folks using the SQL Server 2008 R2. The
reporting services integration for those servers works differently from that of SQL
Server 2012. With the release of SQL Server 2012 SP1 and the SharePoint 2013,
reporting services gets turbocharged especially for Power View.
In conclusion, the topic provides a complete reference to SSRS 2012 covering
both modes of implementation, Native and SharePoint Integrated mode. In the
introductory chapters, the installation, configuration of SQL Server 2012, the
SharePoint 2010, and the sample databases are covered followed by details of
reporting services Native mode components and report authoring tools, the
Report Builder 3.0, and the SSDT. Creating reports using the tools and managing
the reports from the Report Manager frontend is covered, all of which by way of
exercises the users can run through guided by numerous screenshots. Two new
features that were introduced with RS 2012 with SharePoint Integration, namely
Power View and self service Data Alerts, are covered in two separate chapters,
Chapter 6
,
Power View and Reporting Services
and
Chapter 7
,
Self-Service Data Alerts
in SSRS 2012
. Configuring RS in SharePoint Integrated mode using Power Shell,
including a section on
Power Shell
as a tool, are described. Programmatic access
to reporting services, cloud-based Windows Azure SQL Reporting, application
access to reports using SSIS, WPF, and SharePoint Web Parts accessing Native
mode reporting services completes the picture.
