Turley P., Bryant T., Counihan J, McKee G, DuVarney D. Professional SQL Server Reporting Services

Wiley, 2004 - 620 p. - ISBN: 0-7645-6878-7.SQL Server Reporting Services is a serious reporting platform that delivers real business intelligence to knowledge workers and business decision-makers. It can render reports in many different formats and also execute those reports on demand, cache, archive, or automatically deliver them to users. Whether you need reports to extend a custom desktop application, website, or a simple out-of-the-box reporting solution, Reporting Services can make it happen. The fact that Microsoft makes this capability available as an extension to their flagship database product with no additional investment is exciting news.Whether you're a novice or an advanced-level programmer, you'll learn to create reports with the right tools for the job. We start with the architecture of Reporting Services and learn about the foundation of .NET and XML web services. You will learn how easy it is to design reports practically for any data source. We cover the basics thoroughly and show you everything you need to get started, working through the processes of report authoring, management, and delivery. You'll create dynamic, interactive reports with drill-down and drill-through features. With the use of tables, groupings, subreports, matrices, images, and charts, reports can be attractive and to the point. You'll use the Report Manager to configure and execute reports. Next, we'll extend the capabilities of advanced reports using .NET programming code and custom expressions.After several comprehensive exercises in report design, we will build custom viewing and management tools for advanced reporting solutions. You'll learn to use objects in code and script to render reports, create custom data processing extensions, and manage security and subscriptions. You'll learn how to design and extend reports with the Report Definition Language (RDL).Finally, we'll put all the pieces together and discuss designing complete solutions and deploying reports and Reporting Services in your business environment. Five experienced authors have worked very hard over several months to make this book a comprehensive tutorial and source of useful information. We sincerely hope it will be a valuable addition to your reference library.