Pro SQL Server 2008 Reporting Services (eBook)

strongRodney Landrum/strong is a MCSE working as a systems engineer, database administrator, 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 emWindows and .NET/em, emSQL Server/em, emConnected Home/em, emT-SQL Solutions/em, emMicrosoft Certified Professional/em, and emElectronic House/em.

Contents at a Glance 5
Contents 6
About the Authors 11
About the Technical Reviewer 12
Acknowledgments 13
Introduction 15
What This Book Covers 16
Who This Book Is For 17
Source Code 18
Introducing the Reporting Services Architecture 19
Understanding the Benefits of SSRS 20
Exploring the SSRS Architecture 25
Installing and Configuring 32
Deploying SSRS Securely 32
Summary 33
Report Authoring: Designing Efficient Queries 34
Introducing the Sample Relational Database 35
Introducing Query Design Basics 38
Using a Parameterized Stored Procedure 46
Summary 51
Introduction to Reporting Services Design 52
Exploring the Elements of BIDS 53
Laying Out a Report 68
Summary 101
Building Reports 102
Creating a Report with the Report Wizard 103
Building Reports from Scratch 106
Setting Report Parameters with Stored Procedures 134
Working with Multivalued Parameters 141
Adding Tablix Elements 151
Report and Group Variables 153
Adding the New Gauge Control 154
Adding the Final Touches 156
Summary 158
Using Custom .NET Code with Reports 159
Using Embedded Code in Your Report 160
Using Custom Assemblies with Your Report 168
Summary 182
Rendering Reports from .NET Applications 183
Implementing URL Access 185
Integrating SSRS 2008 with .NET Applications 189
Summary 215
Deploying Reports 216
Using Report Manager 217
Using Report Builder 2.0 221
Using BIDS and Visual Studio 2008 223
Using the rs.exe Utility 226
Using the Report Server Web Service 230
Summary 241
Managing Reports 242
Exploring Management Roles in SSRS Deployment 242
Managing Content 243
Performing Execution Auditing and Performance Analysis 266
Controlling SSRS Programmatically 273
Summary 286
Securing Reports 287
Encrypting Data 288
Setting Up Authentication and User Access to Data 299
Auditing Reports 313
Exploring Deployment Models 314
Summary 320
Delivering Business Intelligence with SSRS 321
Building SSRS Reports for SQL Analysis Services 322
Incorporating SSRS with Microsoft Office SharePoint Services 2007 332
Summary 350
Creating Reports Using Report Builder 1.0 and 2.0 351
Getting User Feedback 352
Introducing the Report Model 354
Creating Reports with Report Builder 1.0 372
Creating Reports with Report Builder 2.0 392
Summary 403
Index 404