Introduction to SQL Server Reporting Services.
Sylvain Duford.
SQL112
These session notes serve primarily to share the content of the session and as a reference for me. They may also provide some value to those interested in the session topics. Some of the information found in these notes may be inaccurate due to my typing errors or a lack of understanding of the subject matter. DevTeach policy is that session material is available online to registered attendees only, so I cannot respond to any requests for session PPTs or source.
Authoring - Report Designer
Reporting Services XML Report Definition Language (RDL) Open standard.
Designer integrated with VS.NET
Full VB.NET expression language
Report Management
Everything is exposed as a web service API.
Web and Win32 management user interfaces.
Report Delivery
Pull and push. Web-based or subscription receipt. Format can be set with each subscription: HTML, RTF, PDF, Excel, XML, CSV.
Report Manager - web-based report designer. URL can be used in applications to control rendering and other display aspects. Just plug the URL into your app for the desired report. A lot of functionality that we don't have to write. Very sweet.
Visual product catalog in sample reports with HTML document map on left-hand side. Sweet.
Drill-down example. End result being a single sales order.
Embedded charting example included.
Report designer contains drag-drop data, layout and preview components.
Http://servername/ReportServer
Ms.com/sql/reporting
Sqljunkies/weblog
Summary: Nothing else in this time spot excited me, and SQL Reporting Services are definitely something I want to implement. I should have had working knowledge of this by now, but hey. Good overview of SQL Server Reporting Services. 8 out of 10.