MS BI TOOLS

MICROSOFT BUSINESS INTELLIGENCE

Monday, November 22, 2010

Brief Introduction to SSRS

SQL Server Reporting Services

SQL Server Reporting Services provides a server-based platform, designed to support a wide variety of  reporting needs, including managed enterprise reporting, special purpose reporting, embedded reporting, and web based reporting. SQL reporting services provides wide range of tools and

services to help us to create, deploy, manage and deliver reports as well as programming features that enable us to extend and customize reporting functionality.

SQL Server Reporting

SQL Server Reporting Services (SSRS) Features

SQL Server Reporting Servicess / SQL Reporting Services is a enterprise level reporting system, capable of generating complex reports.  We use the capabilities built into it to deliver the varied needs of our clients. With SSRS we can create the following types of reports:
  • Parameterized Reports SQL Server Reporting Services
  • Linked Reports
  • Snapshot Reports
  • Cached Reports
  • Ad hoc Reports
  • Clickthrough Reports
  • Drilldown Reports
  • Drillthrough reports
  • Subreports

SQL Server Reporting Services (SSRS) System


Integrating SQL Server Reporting Services/SQL Reporting Services into an application is for managing all the reporting needs. It can also be used to integrate SSRS into an existing application to meet their reporting needs. Apart from being able to create a new system for an existing application, we need to have the ability to support and enhance/upgrade existing SQL Reporting tools.

SQL Server Reporting Services (SSRS) Industries


SQL Reporting Services is the primary choice where the reporting needs are exhaustive. Again the needs vary depending on the industry to which the core application caters too. We have done extensive reporting for some of these industries:
  • Health-Care Industry
  • Insurance Group industry
  • Logistics Industry
  • Oil & Gas Industry
  • Food & Beverages industry
  • University / School Sports Websites

         SSRS components include:
  • Report Server - the report processing engine and databases
  • Report Designer - the main report design environment, which runs in SQL Server's Visual Studio shell Business Intelligence Development Studio (BIDS)
  • Report Manager - a web-based interface used to manage reports, security, subscriptions, data sources, and more
  • Other components for administration, and other functionality

         In the next post I will demonstrate how to create a new SSRS project, a shared data source, and a 
         report based on the database.

No comments:

Post a Comment