SSRS 2012 Introduction to SQL Server Reporting Services
In this article i will be explaining the scenarios for using SQL Server Reporting SSRS 2012 and a small introduction to reporting services
SSRS provides the ability to present information from both Analysis Services cubes and relational data sources as reports.
With flexible report designs and a vast improvement on the visualisation of reports, you have the ability to create compelling reports.
Furthermore, interactivity can be added to allow the end user to become involved with the reports. This can be as simple as adding interaction in the form of parameter lists or drill through.
You can also empower end users to create their own reports by using Report Builder. All of this can be managed with a simplified, Web-based interface that allows you to host and deliver reports when the user needs it.
SSRS provides a complete set of tools and a streamlined server
architecture that is designed to support the reporting requirements across the
enterprise, from a wide variety of data sources at a reduced total cost of
ownership.
Extensive enhancements have been introduced to the authoring capabilities
within Reporting Services 2008 2012, providing the ability to create comprehensive,
richly formatted reports quickly and easily through a variety of reporting
tools.
The reports created are stored within a Report Definition
Language (RDL) file.
Reporting Services can also be tightly integrated with MOSS and provide
highly customised applications within Microsoft Visual Studio 2008 2012 through
the use of report viewer controls.
A restructuring of the server architecture has reduced the configuration and
maintenance tasks required to manage Reporting Services.
For example, the
dependency on IIS has now been removed, reducing the need to configure multiple
service accounts.
A redesigned report and rendering engine delivers reports of
any scale more efficiently.
Microsoft Word 2007 has been introduced as a new, out-of-the-box
rendering format.
The delivery of reports can also be managed through
subscriptions that can be controlled by the user or the administrator.
With SSRS 2008, you can create, manage and deploy reports much more
efficiently.
Scenarios for Using SQL Server Reporting Services 2012
SQL Server Reporting Services 2008 is installed as part of the SQL Server
setup.
When Reporting Services is selected in the features selection screen,
the Reporting Services Configuration screen provides three options that can be
selected to determine how Reporting Services can be accessed. This can be
useful if Reporting Services is to be used by internal users, external users or
if you wish to integrate Reporting Services with Microsoft Office SharePoint
Server.
By selecting the Install in Native Mode default configuration option,
Reporting Services is installed with all of the default options and is
operational once the installation is complete.
This is an ideal choice if the
Reporting Services solution is to be used by internal users only and you do not
wish to change the default settings.
Users will access the reports by typing
the URL in Internet Explorer that goes to http://ServerName/reports.
The installation allows you to integrate Reporting Services with Microsoft
Office SharePoint Server. Assuming the Reporting Services pack is already
installed on the SharePoint Server, Reporting Services will be installed in
SharePoint integrated mode whereby the user will access the reports from the
SharePoint site rather than the Reporting Services home page. Reporting
Services can also use the features available to SharePoint Server as well.
For external access, it is best practice to select the Install, but do not
configure the report server option in the Reporting Services Configuration
screen.
In this scenario, you will have to use Reporting Services Configuration
Manager to manually set the values for the home page of the Report Server Web
site, Report Manager Web site and determine how the Report Server databases are
created.
Furthermore, you will have to modify configuration files to secure the
traffic that is sent between the Report Server and the external clients.
0 comments:
Post a Comment