| 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 |