The great webcast series on SQL Server 2005 Reporting Services is now available on demand.
Session One: Introduction. This webcast gives a flavor of the entire report lifecycle: report design, report management, and report delivery.
Session Two: Delivering reports. This webcast is about ways to get reports to users. I showed an ASP.NET application that integrates with a report by linking to a report URL, a Windows Forms application that called the web service to browse available reports and then displays the report in a browser, building standard and data-driven report subscriptions, and uaing the Windows Forms control from Visual Studio 2005.
Session Three: Report Builder. Everything you always wanted to know but were afraid to ask about ad hoc reports. How does a user create an ad hoc report? What does a developer have to do to make the database available to end users?
Session Four: Report Design. I build reports with tables. I build reports with matrices. I build reports with lists. I build reports with charts. I build reports that link to other reports.
Session Five: Extensibility. Our intrepid hero calls custom code from a report. He gets data from a web service. He does a directory of the file system using a custom data source. He even uses a third-party charting control for Reporting Services.
Session Six: Management and Security. We learn about SQL Server Management Studio, and see the security model for reporting services. We also see diagrams of a scale-out architecture for a high-capacity, fault tolerant, enterprise grade reporting solution.