World Library  
Flag as Inappropriate
Email this Article

SQL Server Reporting Services

Article Id: WHEBN0004198408
Reproduction Date:

Title: SQL Server Reporting Services  
Author: World Heritage Encyclopedia
Language: English
Subject: Business Intelligence Development Studio, Crystal Reports, List of Microsoft codenames, SQL Server Agent, MRS
Collection:
Publisher: World Heritage Encyclopedia
Publication
Date:
 

SQL Server Reporting Services

SQL Server Reporting Services (SSRS) is a server-based report generation 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.

History

Reporting Services was first released in 2004 as an add-on to SQL Server 2000. ...The second version was released as a part of SQL Server 2005 in November 2005. A third version was released as part of SQL Server 2008 R2 in April 2010. A fourth version was released as part of SQL Server 2012 in March 2012. The latest version was released as part of SQL Server 2014 in March 2014.

Packaging

Use

The benefit of using SQL Server Data Tools for Business Intelligence (SSDT BI - available for free from Microsoft) is that the RDL (Report Definition Language) component is reduced 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.[4] Publishing reports in Windows Azure is also supported.[5]

References

  1. ^ MSDN Library: Reporting Services in SQL Server Express with Advanced Services
  2. ^ MSDN Library: Reporting Services Render Method - See Device Information Settings
  3. ^ Image Device Information Settings - SSRS can render BMP, EMF, GIF, JPEG, PNG, and TIFF.
  4. ^ MSDN Library: View Reporting Services Reports on Microsoft Surface Devices and Apple iOS Devices
  5. ^ Windows Azure Documentation: Learn SQL Reporting on Windows Azure (Tutorial)

External links

  • Microsoft SQL Server: Reporting Services home page
  • Microsoft SQL Server: Reporting Services resources page
  • DNR TV: Reporting Services Part A
  • DNR TV: Reporting Services Part B
  • DNR TV: Reporting Services Part C
  • SSRS with Visual Basic and Visual C#
  • SSRS in your ASP.Net application
  • PHP library for connecting to SSRS over SOAP
  • Creating a Java proxy for SSRS
  • Custom SSRS solution I white paper by MindHARBOR
  • Microsoft SQL Azure Enterprise Application Development, ISBN 978-1-849680806, Jayaram Krishnaswamy, 2010
  • Learn SQL Server Reporting Services 2008, ISBN 978-1-847196187, Jayaram Krishnaswamy, 2008
  • Learning SQL Server Reporting Services 2012, ISBN 978-1-849689922, Jayaram Krishnaswamy, 2013
This article was sourced from Creative Commons Attribution-ShareAlike License; additional terms may apply. World Heritage Encyclopedia content is assembled from numerous content providers, Open Access Publishing, and in compliance with The Fair Access to Science and Technology Research Act (FASTR), Wikimedia Foundation, Inc., Public Library of Science, The Encyclopedia of Life, Open Book Publishers (OBP), PubMed, U.S. National Library of Medicine, National Center for Biotechnology Information, U.S. National Library of Medicine, National Institutes of Health (NIH), U.S. Department of Health & Human Services, and USA.gov, which sources content from all federal, state, local, tribal, and territorial government publication portals (.gov, .mil, .edu). Funding for USA.gov and content contributors is made possible from the U.S. Congress, E-Government Act of 2002.
 
Crowd sourced content that is contributed to World Heritage Encyclopedia is peer reviewed and edited by our editorial staff to ensure quality scholarly research articles.
 
By using this site, you agree to the Terms of Use and Privacy Policy. World Heritage Encyclopedia™ is a registered trademark of the World Public Library Association, a non-profit organization.
 


Copyright © World Library Foundation. All rights reserved. eBooks from Project Gutenberg are sponsored by the World Library Foundation,
a 501c(4) Member's Support Non-Profit Organization, and is NOT affiliated with any governmental agency or department.