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.
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 O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's 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 booktech@oreilly.com.
Getting Started with Reporting Services
Chapter 1 Understanding Reporting
Reporting Scenarios
Reporting User Communities
The Enterprise Reporting Life Cycle
Reporting Services Components
Quick Reference
Chapter 2 Installing Reporting Services
Considering Deployment Options
Preparing for Installation
Installing Reporting Services
Quick Reference
Chapter 3 Building Your First Report
Authoring a Report
Managing a Report
Accessing a Report
Quick Reference
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
Quick Reference
Chapter 5 Working with Expressions
Using Expressions to Calculate Values
Using Aggregate Functions
Using Expressions to Change an Object’s Behavior
Quick Reference
Chapter 6 Organizing Data in Reports
Understanding Data Regions
Using a Matrix
Using a Chart
Using a List
Quick Reference
Chapter 7 Building Advanced Reports
Using Parameters to Change Report Data
Linking Information with Interactive Features
Working with Hierarchical Data
Quick Reference
Chapter 8 Building Report Models
Understanding Report Models
Creating a Report Model
Modifying a Report Model
Managing a Report Model
Quick Reference
Managing the Report Server
Chapter 9 Managing Content
Publishing Reports
Organizing Content
Using Properties to Manage Report Content
Managing Report Execution
Quick Reference
Chapter 10 Managing Security
Using Report Server Security
Applying Data Security
Quick Reference
Chapter 11 Managing Server Components
Configuring Reporting Services
Managing the Report Server
Administering Reporting Services Databases
Quick Reference
Delivering Reports
Chapter 12 Accessing Reports
Finding and Viewing Reports
Saving Reports for Future Reference
Quick Reference
Chapter 13 Rendering Reports
Comparing Rendering Formats
Rendering for Online Viewing
Rendering for Document Management
Rendering for Data Exchange
Quick Reference
Chapter 14 Managing Subscriptions
Creating a Standard Subscription
Creating a Data-Driven Subscription
Managing Subscriptions
Quick Reference
Chapter 15 Creating Reports with Report Builder
Building Basic Reports
Enhancing Reports
Quick Reference
Programming Reporting Services
Chapter 16 Report Authoring with Custom Development
Using Custom Code
Creating Custom Data Processing Extensions
Generating Report Definition Language
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
Quick Reference
Chapter 18 Building Custom Reporting Tools
Using URLs
Using the Web Service
Quick Reference
Glossary
Appendix About the Authors
Appendix Contributing Authors
Title:
Microsoft® SQL Server™ 2005 Reporting Services Step by Step
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