Pro SQL Server 2005 Reporting Services - Brossura

Landrum, Rodney

Brossura

ISBN 10: 1590594983 ISBN 13: 9781590594988

Casa editrice: Apress, 2010

Riassunto

SQL Server Reporting Services (SSRS) 2005 is the latest version of the reporting technology from Microsoft. This book examines all of the technology that SSRS provides to design, author, render and deploy professional business reports to the Web or to the company intranet (in a variety of formats, from HTML to XML, PDF, or TIFF), with detailed examples at every step.

It covers all of the new functionality present in the 2005 version, including the new management and business intelligence development studios, as well as the new report viewer controls and end-user reporting tools. It also contains significantly expanded chapters on business intelligence, along with a wealth of tips and workarounds for effective development with SSRS.

The authors are both highly experienced with SQL Server and with business reporting in the medical industry, which is subject to rigorous HIPAA regulations and strict security. It is not their intention to evangelize the product or present "idealized" examples based on the simple built-in schemas. Instead, they take a hard, critical look at the technology and provide exactly what the reader needs to know to deliver effective reports. Their code examples are based on real, complex schemas and the need to deliver versatile, dynamic reports, as well as on strict security and performance requirements.

In summary, this book will provide you with step-by-step guides, best practices, and real code examples covering all of the common Reporting Services tasks, including:

• A detailed overview of the reporting architecture and tools
• The new Report Definition Language Standard, which is XML-based and allows you to define reports in VS.NET
• Building effective queries for high-performance reporting
• Building custom .NET applications with SSRS
• Rendering reports to HTML, XML, PDF and Excel
• Deploying secure reports, using Windows authentication through Active directory
• Business Intelligence reporting using SQL Server Analysis Services

Su questo libro

L'autore:

Walter J. Voytek, II is founder, chief executive officer, and president of HealthWare Corporation, a Microsoft Certified Partner that specializes in IT solutions for the healthcare industry. Voytek has worked in IT for over 30 years, and he spent the past 20 years in healthcare IT. Voytek has spoken publicly at several national conventions and continues to speak at various HealthWare gatherings each year. As chief software architect for HealthWare, Voytek has helped shape the company's award-winning solutions.

Contenuti:

About the Authors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii

About the Technical Reviewers. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv

Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvii

Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xix

¦CHAPTER 1 Introducing the Reporting Services Architecture . . . . . . . . . . . . . . . . . 1

¦CHAPTER 2 Report Authoring: Designing Efficient Queries . . . . . . . . . . . . . . . . . . 17

¦CHAPTER 3 Using Report Designer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35

¦CHAPTER 4 Building Reports. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81

¦CHAPTER 5 Using Custom .NET Code with Reports . . . . . . . . . . . . . . . . . . . . . . . . 123

¦CHAPTER 6 Rendering Reports from .NET Applications. . . . . . . . . . . . . . . . . . . . . 147

¦CHAPTER 7 Deploying Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 175

¦CHAPTER 8 Managing Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 197

¦CHAPTER 9 Securing Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 249

¦CHAPTER 10 Delivering Business Intelligence with SSRS. . . . . . . . . . . . . . . . . . . . 285

¦CHAPTER 11 Performing Ad Hoc Reporting Using Report Builder . . . . . . . . . . . . 321

¦INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 363

Su questa edizione

• Editore: Apress
• Data di pubblicazione: 2010
• ISBN 10: 1590594983
• ISBN 13: 9781590594988
• Rilegatura: Copertina flessibile
• Numero di pagine: 400