Intro SQL Server Reporting Services – SRSS (9 Videos)

Here is a collection of video tutorials on SQL Server Reporting Services (SSRS).

SQL Server Reporting Services (SSRS) is from Microsoft abd it is a server-based report generation software system. It can be used to create a variety of interactive and printed reports. It is administered via a web interface. Reporting services features a web services interface to support the development of custom reporting applications.

SSRS competes with Crystal Reports and other business intelligence tools, and is included in Express, Workgroup, Standard, and Enterprise editions of Microsoft SQL Server as an install option. 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. The latest version was released as part of SQL Server 2008 in August 2008.

Reports are defined in Report Definition Language (RDL) in SSRS. RDL is an XML markup language. Reports can be designed using recent versions of Microsoft Visual Studio with the included Business Intelligence Projects plug-in installed or with the included Report Builder, a simplified tool that does not offer all the functionality of Visual Studio. Reports defined by RDL can be generated in a variety of formats including Excel, PDF, CSV, XML, TIFF (and other image formats), and HTML Web Archive. SQL Server 2008 SSRS can also prepare reports in Microsoft Word (DOC) format.

Users can interact with the Report Server web service directly, or instead use Report Manager. The Report Manger is 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. Reports can be delivered via e-mail or placed on a file system. 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.

In addition to using the standalone Report Server that comes with SQL Server, RDL reports can also be viewed using the ASP.NET ReportViewer web control or the ReportViewer Windows Forms control. This allows reports to be embedded directly into web pages or .NET Windows applications. The ReportViewer control processes reports in one of two ways:

• server processing, where the report is rendered by and obtained from the Report Server;
• local processing, where the control renders the RDL file itself

  SQL 2005 reporting services also support ad hoc reports. When creating 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.

  The next release of Reporting Services is scheduled to be released in 2009 and is part of a larger Business Intelligence release code named Kilimanjaro.

  Related Resources

  • Microsoft SQL Server: Reporting Services home page
  • SSW: Rules to Better SQL Reporting Services 2005
  • SSW: Microsoft SQL Reporting Services Suggestions
  • DNR TV: Reporting Services Part A
  • DNR TV: Reporting Services Part B
  • DNR TV: Reporting Services Part C
  • ReportViewer Control in Visual Studio 2008: Got Report Viewer?

  Intro to SQL 2005 Reporting Services

  Series	Title	Date	Presenter	Min
  Intro to SQL Reporting Services	Intro to SQL Server 2005 Reporting Services (Part 1 of 6)	10/03/2005	Geoff Snowman	100
  Intro to SQL Reporting Services	Intro to SQL Server 2005 Reporting Services (Part 2 of 6)	10/05/2005	Geoff Snowman	80
  Intro to SQL Reporting Services	Intro to SQL Server 2005 Reporting Services (Part 3 of 6)	10/07/2005	Geoff Snowman	86/span>
  Intro to SQL Reporting Services	Intro to SQL Server 2005 Reporting Services (Part 4 of 6)	10/10/2005	Geoff Snowman	89
  Intro to SQL Reporting Services	Intro to SQL Server 2005 Reporting Services (Part 5 of 6)	10/12/2005	Geoff Snowman	82
  Intro to SQL Reporting Services	Intro to SQL Server 2005 Reporting Services (Part 6 of 6)	10/14/2005	Geoff Snowman	98
  Intro to SQL Reporting Services	Intro to SQL Server 2005 Reporting Services	2/13/2006	Brain Welcker	67
  Intro to SQL Reporting Services	Intro to SQL Server 2005 Reporting Services	7/05/2006	John Weston	64
  Intro to SQL Reporting Services	Intro to SQL Server 2005 Reporting Services	4/12/2007	John Weston	84