Pro SQL Server 2005 Reporting Services, Apress
Microsoft .NET Framework, ASP.NET, Visual C# (CSharp, C Sharp, C-Sharp) Developer Training, Visual Studio
|
Contents |
C# Online.NET Book Review
SQL Server Reporting Services (SSRS) 2005 is a server-based reporting solution designed to help developers author, manage, and deliver both paper-based and interactive Web-based reports. Reporting Services is integrated with the Microsoft business intelligence framework. Reporting Services combines the data management capabilities of SQL Server and Windows Server with familiar Microsoft Office applications to deliver real-time information to support daily operations and drive decisions.
Despite the word Pro in the title, this book is an introductory text to SSRS. It does a good job of covering the fundamentals and simple reporting needs. However, it does not cover complex reporting situations. But, for the SSRS newcomer, it is a great place to start.
The book covers a wide variety of topics without getting too detailed. There is good coverage of extending Microsoft Customer Relationship Management (CRM), query optimization, and SharePoint Portal Server (SPS).
All source code examples are in the C# language.
Bottom line
Pro SQL Server 2005 Reporting Services is a good starter text for beginners in SQL Server Reporting Services.
Other books in this series
Publisher's description
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 BI 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
About the author(s)
Rodney Landrum is a MCSE working as a systems engineer, DBA, and data analyst for a software development company in Pensacola, Florida, that specializes in applications for the healthcare industry. He writes software reviews and feature articles for numerous magazines, including Windows and .NET, SQL Server, Connected Home, T-SQL Solutions, Microsoft Certified Professional, and Electronic House.
Walter J. Voytek II is founder, CEO, 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.
Table of Contents (abbreviated)
CHAPTER 1 Introducing the Reporting Services Architecture
CHAPTER 2 Report Authoring: Designing Efficient Queries
CHAPTER 3 Using Report Designer
CHAPTER 4 Building Reports
CHAPTER 5 Using Custom .NET Code with Reports
CHAPTER 6 Rendering Reports from .NET Applications
CHAPTER 7 Deploying Reports
CHAPTER 8 Managing Reports
CHAPTER 9 Securing Reports
CHAPTER 10 Delivering Business Intelligence with SSRS
CHAPTER 11 Performing Ad Hoc Reporting Using Report Builder
