A server-based report generating software system from Microsoft. It is part of suite of Microsoft SQL Server services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services). While SSAS enables users to construct special databases for fast analysis of very large amounts of data, and while SSIS enables users to integrate data from many sources outside Microsoft SQL Server, SSRS enables users to quickly and easily generate reports from Microsoft SQL Server databases.

The SSRS service provides a unique interface into Microsoft Visual Studio so that developers as well as SQL administrators can connect to SQL databases and use SSRS tools to format SQL reports in many complex ways. SSRS also provides a 'Report Builder' tool for less technical IT workers to format SQL reports of lesser complexity.

Administered via a Web interface, it can be used to prepare and deliver a variety of interactive and printed reports. SSRS competes with Crystal Reports and other business intelligence tools.

Use of SQL Server Data Tools for Business Intelligence (SSDT BI) educes the RDL (Report Definition Language) component to graphic icons in a GUI (Graphical User Interface). In this way, instead of writing code, the user can drag-and-drop graphic icons into an SSRS report format for most aspects of the SSRS report.

Reports defined by RDL can be downloaded to a variety of formats[2] including Excel, PDF, CSV, XML, TIFF (and other image formats[3]), and HTML Web Archive.

SQL Server 2008 and 2012 SSRS can also prepare reports in Microsoft Word (DOC) format. Third-party report generators offer additional output formats.

Users can interact with the Report Server web service directly, or instead use Report Manager, a Web-based application that interfaces with the Report Server web service. With Report Manager, users can view, subscribe to, and manage reports as well as manage and maintain data sources and security settings. Report Manager can also deliver SQL reports by e-mail, or place them on a file share.

Security is role-based and can be assigned on an individual item, such as a report or data source, a folder of items, or site wide. Security roles and rights are inherited and can be overloaded.

One can view RDL reports by using the standalone Report Server that comes with Microsoft SQL Server, or by using the ASP.NET ReportViewer web control, or by using the ReportViewer Windows Forms control. The latter method allows reports to be embedded directly into web pages or .NET Windows applications. The ReportViewer control will process reports by: (a) server processing, where the report is rendered by the Report Server; or (b) local processing, where the control renders the RDL file itself.

SQL Server Reporting Services also support ad hoc reports: the designer develops a report schema and deploys it on the reporting server, where the user can choose relevant fields/data and generate reports. Users can then download the reports locally.

Microsoft SQL Server 2012 SP1 expands Microsoft support for viewing reports to mobile platforms, including Microsoft Surface, Apple iOS 6 and Windows Phone 8.

SQL Server Reporting Services (SSRS)

FSL Consulting offers a one stop Business Solution through our specialized business units, such as – Financial Solutions, Software Development and Hardware & Networking solutions. We are present throughout sub-Saharan Africa. FSL Consulting is a South African based consulting company servicing sub-Saharan African including Namibia, Botswana, Mozambique, Swaziland, Zambia, and Mauritius. With a proven track record as committed technology service provider since 1999, FSL Consulting is dedicated to ensuring the provision of cost effective and professionally implemented business solutions.

We`ll come to you 

© 2016 FSL Consulting. All rights reserved.

Our Offer:

Accurate data & Updates in real time

Remove the need to guess or estimate

Quicker Responses

Get immediate answers to your business questions

Metrics any time any place

 Business data can be accessed and utilized by key people from the organization

Develop efficiency

 Remove inefficiencies from the process wasting time and energy

Gain a better understanding

Plan better for your company’s future

Customer service

Transform your business into a customer efficient organization

Microsoft SQL Reporting & Consulting

Bespoke Business Intelligence Solutions

Enhance Productivity, Customer Satisfaction, Flexibility & Control:

Bespoke Business Intelligence Solutions

SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft. It is part of the suite of Microsoft SQL Server Services, including SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services).