Microsoft SQL Server enterprise edition comprises of several database applications and tools such as SQL Server Relational Database, SQL Server Analysis Services, SQL Reporting Services (SRS) and SQL Server Business Intelligence Studio. As of today, many corporations are using SQL Reporting Service (SSRS) to manage their enterprise wide application reporting systems. SRS provides scalable, web based reporting services that can be seamlessly integrated with corporate Business Intelligence (BI) data store, custom build .NET application database, Microsoft SharePoint Server and Microsoft Project Server. SRS offers options to deploy simple text based and graphical reports that can be accesses online via simple web browser. SRS offers enterprise reporting features using ad-hoc reporting, embedded reporting and web based reporting. From security standpoint, SRS offers features such as report authoring, report management and report delivery that can be integrated with Active Directory security for restricted access. SRS provided optimum security for data access to multi-level user hierarchy in enterprise environment. SRS also has scheduled service using which, Reporting administrator can schedule jobs to email reports to specific set of users on a periodic basis. These features helps medium to high level management in gaining quick access to critical business information on routine basis in a simple communication channel such as Email. SRS also has a rich web user interface that provides users with an option to export report data into popular Microsoft Office document such as word or excel or Portable Document Format (PDF) files. Microsoft SQL Server Business Intelligence Studio provides simple & easy to use IDE to create/design reports for developers.

SRS has some new features that provide easy integration facility between SRS reports and Microsoft SharePoint Server. Microsoft SharePoint Server can be used by any level of organization employees to connect to corporate business intelligence (BI) data store to view reports and take daily business decision. Microsoft SharePoint Server integration aims at providing low cost high return on investment (ROI) by eliminating usage of expensive business intelligence tool such as Business Objects or SAS.

SQL Server Service provides seamless integration between SRS and Microsoft SharePoint technologies. End users can view and manage reports from within a SharePoint document library using this integration facility. It provides an option to store SRS reports within a SharePoint Server, which is called as "SharePoint Integration Mode" vs. storing within reporting database, which is called as "Native Mode". Using integrated mode, user can manage report parameters, processing options and report history from within SharePoint document library.

• SQL Reporting Services integration with Dynamics AX (formely Axapta)
• SQL Reporting Services integration with Dynamics NAV (formely Navision)
• SQL Reporting Services integration with Dynamics SL (formely Solomon)
• SQL Reporting Services integration with Dynamics GP (formely Great Plains)

Excel provides out-of-box features that enable users to access SQL Server analysis service to extract data from OLAP cubes. It also enables users to build PivotTable views to “slice and dice” data in their desired fashion. 

Please visit Microsoft SQL Server Reporting Services official website for more information.