You don't have to be a database expert to create high-quality, high-impact reports with SQL Server 2005 Reporting Services (SSRS). Whatever your reporting needs or your technical expertise, you can quickly become comfortable and productive with SSRS. From the simplest reports, to graphical and Web-deployed presentations, to report security and administration, everything you need to know, and how to do it efficiently and proficiently, is clearly explained in Pro SQL Server 2005 Reporting Services.
Since its release in 2004, SSRS has become one of the premier reporting environments because it comes free with SQL Server, is easy to use, and offers a comprehensive set of features that are matched by few competitors. With SQL Server 2005, SSRS is even more powerful and user friendly. If you have SQL Server 2005 and aren't using Reporting Services, it's time to start. Pro SQL Server 2005 Reporting Services will get you off to the fastest start and will quickly make you an SSRS expert.
Pro SQL Server 2005 Reporting Services carefully examines all SSRS features for designing, developing, deploying, and administering professional business reports in a variety of presentation styles and delivery formats. Intended for all levels of SSRS users, it provides in-depth explanations and detailed examples of the most important SSRS features, with practical guides, tips, best practices, and code based on complex real-world reporting requirements. It covers all of the new functionality of SSRS 2005, including the new management and business intelligence (BI) development studios as well as new report viewer controls and end-user reporting tools. The emphasis throughout is on understanding what SSRS can do and learning the most effective techniques for exploiting its power.
Pro SQL Server 2005 Reporting Services introduces the SSRS architecture and tools, but it also explores many advanced features, including: high-performance queries; the Report Definition Language standard; rendering reports in HTML, XML, PDF, and Excel; report administration and security; building custom .NET applications with SSRS; and integrating SSRS with Analysis Services and other BI tools and products.
The authors are experienced professionals in medical business reporting, which is subject to rigorous HIPAA regulations and strict security. They take a hard, critical look at how SSRS can provide exactly what is needed to deliver enterprise-level reports that satisfy stringent business and legal requirements. Their code examples are based on real-world demands for versatile, dynamic, incisive information delivery that truly enhances business decision-making.
Anyone who needs to create, manage, or distribute any kind of business information can quickly become an SSRS expert with Pro SQL Server 2005 Reporting Services!
| Ch. 1 | Architecture and overview | 1 |
| Ch. 2 | Report authoring : designing efficient queries | 15 |
| Ch. 3 | The report designer | 31 |
| Ch. 4 | Building reports | 73 |
| Ch. 5 | Using custom .NET code with reports | 105 |
| Ch. 6 | Rendering reports from .NET applications | 123 |
| Ch. 7 | Deploying reports | 145 |
| Ch. 8 | Report management | 163 |
| Ch. 9 | Securing reports | 209 |
| Ch. 10 | Business intelligence and SRS | 237 |
| Ch. 11 | Future SRS | 267 |
Anonymous
Posted October 13, 2004
This book takes you from the basics to very advanced activities. Anyone who is serious about creating custom report solutions should implement SQL RS and use this book. It will help you through step-by-step 'how-to' to create an extremely professional result. Reporting Services is fairly new to the public. Only now are books of this nature becoming available. This one is the best!
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.Anonymous
Posted October 18, 2004
To increase the attractiveness of its SQL Server, Microsoft recently released Reporting Services. These help you generate management level summaries of data stored in SQL Server. The authors show how Microsoft has implemented this in a tight integration with its .NET platform. There are numerous screen captures of the wizard UIs that generate reports. Nice. In parallel with these diagrams are often listings of the corresponding XML data that describe what the diagrams show. The book assumes a reasonable familiarity with XML. But even if you are new to it, the verbosity of XML tags should make the examples self documenting. One thing is clear from this book. The Reporting Services need a programmer to use them. The wizard helps somewhat to reduce the need for explicit coding. But if you have any nontrivial customisation needs, you will need to program. Though the code examples are not that intricate. Which also means that if you are casting around for some programming expertise to develop, as job security perhaps, then do not settle on Reporting Services. If you can, find something more intricate that you can handle. It is a greater barrier to entry.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Overview
You don't have to be a database expert to create high-quality, high-impact reports with SQL Server 2005 Reporting Services (SSRS). Whatever your reporting needs or your technical expertise, you can quickly become comfortable and productive with SSRS. From the simplest reports, to graphical and Web-deployed presentations, to report security and administration, everything you need to know, and how to do it efficiently and proficiently, is clearly explained in Pro SQL Server 2005 ...