Synopses & Reviews
Teach yourself the fundamentals of SQL Server Reporting Servicesone step at a time. With this practical, learn-by-doing tutorial, you get the guidance you need to build flexible and powerful solutions that support the reporting needs of your organization.
Discover how to: Install and configure Reporting Services Author, manage, and access reports Create attractive, information-rich reports with the Report Designer Calculate values, organize information, and manipulate report data Build, deploy, and maintain a report model Render and distribute reports in various formats Implement role-based security to restrict access to information Explore more advanced report design techniques Programmatically customize any stage of the reporting lifecycle
CD features all practice exercises.
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to email@example.com.
Your hands-on, practical guide to Microsoft SQL ServerTM 2005 Reporting Services. Get started using Business Intelligence tools that simplify data analysis and reporting with this popular, learn-by-doing tutorial. Includes a companion CD. Your hands-on guide to learning Microsoft SQL Server Reporting Services, Microsoft's customizable reporting solution for business data analysis. Reporting Services is a powerful tool for business intelligence, so an understanding of the essentials--how to architect a report, as well as how install and program Reporting Services--is key to harnessing the full benefits of SQL Server. This step-by-step tutorial shows you how to get started, how to use the report project wizard, how to think about and access data, and how to build queries. It also walks you through the creation of charts and visual layouts to enable maximum visual understanding of the data analysis. Interactivity features (enhanced in SQL Server 2005) and security are also covered in detail. With Step By Step, you work at your own pace through hands-on, learn-by-doing exercises. Whether you're a beginning programmer or new to this version of the technology, you'll understand the fundamental techniques for using Reporting Services. A companion CD includes data sets and sample code.
Teach yourself the fundamentals of SQL Server Reporting Services—one step at a time. With this practical, learn-by-doing tutorial, you get the guidance you need to build flexible and powerful solutions that support the reporting needs of your organization.
Discover how to:
- Install and configure Reporting Services
- Author, manage, and access reports
- Create attractive, information-rich reports with the Report Designer
- Calculate values, organize information, and manipulate report data
- Build, deploy, and maintain a report model
- Render and distribute reports in various formats
- Implement role-based security to restrict access to information
- Explore more advanced report design techniques
- Programmatically customize any stage of the reporting lifecycle
CD features all practice exercises.
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.
About the Author
Stacia Misner, MCITP, MCTS, is a consultant and trainer specializing in Microsoft business intelligence solutions. She has more than 20 years of IT experience and has written several books on SQL Server, including Microsoft SQL Server 2008 Reporting Services Step by Step. Stacia is also one of the first to earn the new SQL Server Analysis Services Maestro certification.
Hitachi Consulting, a division of Hitachi Ltd., is a global business and IT consulting firm serving Fortune 2000 companies. It is a leader in developing corporate training and custom solutions for Reporting Services
Table of Contents
Introduction; Finding Your Best Starting Point; About the Companion CD-ROM; System Requirements; Installing and Using the Sample Files; Conventions and Features in This Book; Part I: Getting Started with Reporting Services; Chapter 1: Understanding Reporting; Reporting Scenarios; Reporting User Communities; The Enterprise Reporting Life Cycle; Reporting Services Components; 1 Quick Reference; Chapter 2: Installing Reporting Services; Considering Deployment Options; Preparing for Installation; Installing Reporting Services; 2 Quick Reference; Chapter 3: Building Your First Report; Authoring a Report; Managing a Report; Accessing a Report; 3 Quick Reference; Part II: Authoring Reports; Chapter 4: Developing Basic Reports; Understanding a Report Definition File; Preparing a Report Using Report Designer; Structuring a Report Using Report Designer; Formatting a Report Using Report Designer; 4 Quick Reference; Chapter 5: Working with Expressions; Using Expressions to Calculate Values; Using Aggregate Functions; Using Expressions to Change an Objects Behavior; 5 Quick Reference; Chapter 6: Organizing Data in Reports; Understanding Data Regions; Using a Matrix; Using a Chart; Using a List; 6 Quick Reference; Chapter 7: Building Advanced Reports; Using Parameters to Change Report Data; Linking Information with Interactive Features; Working with Hierarchical Data; 7 Quick Reference; Chapter 8: Building Report Models; Understanding Report Models; Creating a Report Model; Modifying a Report Model; Managing a Report Model; 8 Quick Reference; Part III: Managing the Report Server; Chapter 9: Managing Content; Publishing Reports; Organizing Content; Using Properties to Manage Report Content; Managing Report Execution; 9 Quick Reference; Chapter 10: Managing Security; Using Report Server Security; Applying Data Security; 10 Quick Reference; Chapter 11: Managing Server Components; Configuring Reporting Services; Managing the Report Server; Administering Reporting Services Databases; 11 Quick Reference; Part IV: Delivering Reports; Chapter 12: Accessing Reports; Finding and Viewing Reports; Saving Reports for Future Reference; 12 Quick Reference; Chapter 13: Rendering Reports; Comparing Rendering Formats; Rendering for Online Viewing; Rendering for Document Management; Rendering for Data Exchange; 13 Quick Reference; Chapter 14: Managing Subscriptions; Creating a Standard Subscription; Creating a Data-Driven Subscription; Managing Subscriptions; 14 Quick Reference; Chapter 15: Creating Reports with Report Builder; Building Basic Reports; Enhancing Reports; 15 Quick Reference; Part V: Programming Reporting Services; Chapter 16: Report Authoring with Custom Development; Using Custom Code; Creating Custom Data Processing Extensions; Generating Report Definition Language; 16 Quick Reference; Chapter 17: Programming Report Server Management; Understanding Web Services; Using a Custom Application to Manage Reporting Services; Using the Reporting Services WMI Provider; 17 Quick Reference; Chapter 18: Building Custom Reporting Tools; Using URLs; Using the Web Service; 18 Quick Reference; Glossary; Appendix : About the Authors; Appendix : Contributing Authors;