Teach yourself how to build, manage, and access SQL Server 2008 reports—one step at a time. Whether you’re a report developer, IT administrator, or business user, this sequential, learn-by-doing tutorial shows you how to deliver the business intelligence information your organization needs.
Discover how to:
Install and configure Reporting Services
Put Report Builder and Report Designer tools to work
Create interactive, online reports that enable users to sort and filter data
Add charts and gauges to present data visually
Deploy reports to Microsoft Office SharePoint Server
Monitor server performance and help secure content
Use subscriptions to distribute reports via e-mail
Build ad hoc reports and extend them with custom code
CD features:
Practice exercises and code samples
Fully searchable eBook
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 Introducing Reporting Services
A Reporting Platform
Reporting Life Cycle
Reporting Services Architecture
SharePoint integrated Mode
Chapter 1 Quick Reference
Chapter 2 Installing Reporting Services
Planning for Installation
Performing the Installation
Configuring SharePoint Integrated Mode
Chapter 2 Quick Reference
Chapter 3 Exploring Reporting Services
Developing a Simple Report
Managing a Report
Viewing a Report
Chapter 3 Quick Reference
Developing Reports
Chapter 4 Designing Reports
Getting Started with Report Designer
Designing the Report Structure
Enhancing the Report Appearance
Chapter 4 Quick Reference
Chapter 5 Developing Expressions
Adding Calculations to a Report
Using Aggregate Functions
Changing Report Item Properties by Using Expressions
Working with Variables
Using Expressions for Dynamic Connections and Datasets
Developing Expressions for Hierarchical Data
Chapter 5 Quick Reference
Chapter 6 Adding Interactivity
Changing the Report Layout Interactively
Working with Parameters
Adding Navigation Features
Chapter 6 Quick Reference
Chapter 7 Using Analysis Services as a Data Source
Installing the Sample Database
Creating an Analysis Services Dataset
Building a Report
Designing Parameters
Chapter 7 Quick Reference
Chapter 8 Visualizing Data
Creating Charts
Working with Gauges
Chapter 8 Quick Reference
Chapter 9 Developing Report Models
Preparing to Develop a Report Model
Generating a Report Model
Using the Report Model Wizard
Refining a Report Model
Managing a Report Model
Chapter 9 Quick Reference
Managing the Report Server
Chapter 10 Deploying Reports to a Server
Reviewing Deployment Options
Managing Content
Configuring Data Source Properties
Configuring Report Execution Properties
Chapter 10 Quick Reference
Chapter 11 Securing Report Server Content
Configuring Report Server Security Policies
Assigning User Permissions
Configuring Item-Level Security
Implementing Data Security
Chapter 11 Quick Reference
Chapter 12 Performing Administrative Tasks
Using Management Tools
Configuring the Report Server
Monitoring the Report Server
Chapter 12 Quick Reference
Viewing Reports
Chapter 13 Accessing Reports Online
Using Report Manager
Accessing Reports in SharePoint
Exporting Reports
Chapter 13 Quick Reference
Chapter 14 Creating Ad Hoc Reports
Developing Reports with Report Builder
Enhancing Reports
Working with Clickthrough
Chapter 14 Quick Reference
Chapter 15 Working with Subscriptions
Creating Standard Subscriptions
Creating Data-Driven Subscriptions
Managing Subscriptions
Chapter 15 Quick Reference
Using Reporting Services as a Development Platform
Chapter 16 Programming Reporting Services
Programming Report Design Components
Programming Report Server Management
Programming Reporting Access
Chapter 16 Quick Reference
Glossary
Appendix About the Author
Contributing Author
Title:
Microsoft® SQL Server® 2008 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 2005 Reporting Services Step by Step. She is also the coauthor of Microsoft SQL Server 2005 Administrator’s Companion.
Comments about Microsoft Press Microsoft® SQL Server® 2008 Reporting Services Step by Step:
This book is written for 2008. If you've installed 2008R2 this book will serve as a general overview of what is possible, however, there are so many changes in functionality and display that most of the explanations on how to accomplish a task, such as creating click through charts, are inaccurate. We bought the book as a tool for learning SSRS and have managed a basic understanding at best. I cannot recommend this book if you are using 2008 R2.
