SSRS 2012-2008 Introduction to SQL Server Reporting Services

SSRS 2012 Introduction to SQL Server Reporting Services

  1. In this article i will be explaining the scenarios for using SQL Server Reporting SSRS 2012 and a small introduction to reporting services 
  2. SSRS provides the ability to present information from both Analysis Services cubes and relational data sources as reports. 
  3. With flexible report designs and a vast improvement on the visualisation of reports, you have the ability to create compelling reports. 
  4. 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.
  5.  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.
  6. 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.
  7. 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. 
  8. The reports created are stored within a Report Definition Language (RDL) file.
  9. 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.
  10. A restructuring of the server architecture has reduced the configuration and maintenance tasks required to manage Reporting Services.
  11. For example, the dependency on IIS has now been removed, reducing the need to configure multiple service accounts.
  12.  A redesigned report and rendering engine delivers reports of any scale more efficiently.  
  13. Microsoft Word 2007 has been introduced as a new, out-of-the-box rendering format. 
  14. The delivery of reports can also be managed through subscriptions that can be controlled by the user or the administrator.
  15. With SSRS 2008, you can create, manage and deploy reports much more efficiently.

Scenarios for Using SQL Server Reporting Services 2012

  1. SQL Server Reporting Services 2008 is installed as part of the SQL Server setup. 
  2. 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.
  3. 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. 
  4. 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.
  5. Users will access the reports by typing the URL in Internet Explorer that goes to http://ServerName/reports.
  6. 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.
  7. 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. 
  8. 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. 
  9. Furthermore, you will have to modify configuration files to secure the traffic that is sent between the Report Server and the external clients.


Post a Comment