| About the Authors | p. xiii |
| About the Technical Reviewer | p. xv |
| Acknowledgments | p. xvii |
| Introduction | p. xix |
| Introducing the Reporting Services Architecture | p. 1 |
| Understanding the Benefits of SSRS | p. 2 |
| SQL Server 2008 Reporting Services Enhancements | p. 5 |
| SSRS and Business Intelligence | p. 6 |
| Exploring the SSRS Architecture | p. 7 |
| SSRS Databases | p. 8 |
| The SSRS Report Server | p. 9 |
| Client Applications | p. 11 |
| Installing and Configuring | p. 14 |
| Deploying SSRS Securely | p. 14 |
| Summary | p. 15 |
| Report Authoring: Designing Efficient Queries | p. 17 |
| Introducing the Sample Relational Database | p. 18 |
| Introducing the Schema Design | p. 18 |
| Knowing Your Data: A Quick Trick with a Small Procedure | p. 19 |
| Introducing Query Design Basics | p. 21 |
| Creating a Simple Query Graphically | p. 21 |
| Creating an Advanced Query | p. 24 |
| Using a Parameterized Stored Procedure | p. 29 |
| Using Case and ISNULL to Evaluate the Parameters | p. 32 |
| Testing the Procedure | p. 33 |
| Summary | p. 34 |
| Introduction to Reporting Services Design | p. 35 |
| Exploring the Elements of BIDS | p. 36 |
| Setting Up a Basic IDE | p. 38 |
| Understanding Report Definition Language (RDL) | p. 39 |
| Adding a Report | p. 40 |
| Setting Up Data Sources and Datasets | p. 41 |
| Setting Parameters | p. 46 |
| Setting Up Filters | p. 48 |
| Expressions | p. 50 |
| Laying Out a Report | p. 51 |
| Setting Up Pagination | p. 52 |
| Using Report Objects | p. 53 |
| Summary | p. 84 |
| Building Reports | p. 85 |
| Creating a Report with the Report Wizard | p. 86 |
| Building Reports from Scratch | p. 89 |
| Formatting the Output | p. 91 |
| Adding Subtotals | p. 92 |
| Adding Interactivity | p. 95 |
| Setting Report Parameters with Stored Procedures | p. 117 |
| Working with Multivalued Parameters | p. 124 |
| Applying a Filter | p. 130 |
| Adding a Chart | p. 131 |
| Adding Tablix Elements | p. 134 |
| Report and Group variables | p. 136 |
| Adding the New Gauge Control | p. 137 |
| Adding the Final Touches | p. 139 |
| Summary | p. 141 |
| Using Custom .NET Code with Reports | p. 143 |
| Using Embedded Code in Your Report | p. 144 |
| Using the ExceedMaxVisits Function | p. 145 |
| Using the ExceedMaxVisits Function in a Report | p. 148 |
| Accessing .NET Assemblies from Embedded Code | p. 151 |
| Using Custom Assemblies with Your Report | p. 152 |
| Adding a Class Library Project to Your Reporting Solution | p. 153 |
| Deploying a Custom Assembly | p. 156 |
| Adding an Assembly Reference to a Report | p. 160 |
| Debugging Custom Assemblies | p. 163 |
| Troubleshooting Your Project | p. 165 |
| Summary | p. 166 |
| Rendering Reports from .NET Applications | p. 167 |
| Implementing URL Access | p. 169 |
| URL Report Access Path Format | p. 170 |
| URL Parameters and Prefixes | p. 170 |
| Report Parameters | p. 171 |
| HTML Viewer Commands | p. 171 |
| Report Server Command Parameters | p. 172 |
| Credential Parameters | p. 172 |
| Example URLs | p. 173 |
| Integrating SSRS 2008 with .NET Applications | p. 173 |
| Building the Report Viewer Using a WebBrowser Control | p. 174 |
| Building the Report Viewer Using a Report Viewer Control | p. 177 |
| Building the Report Viewer in ASP .NET | p. 195 |
| Summary | p. 199 |
| Deploying Reports | p. 201 |
| Using Report Manager | p. 202 |
| Using Report Builder 2.0 | p. 206 |
| Using BIDS and Visual Studio 2008 | p. 208 |
| Configuring Report Deployment Options | p. 208 |
| Using the rs.exe Utility | p. 211 |
| Using the Report Server Web Service | p. 215 |
| Accessing the Web Service | p. 216 |
| Laying Out the Form | p. 217 |
| Coding the Form | p. 218 |
| Running the Application | p. 224 |
| Summary | p. 226 |
| Managing Reports | p. 227 |
| Exploring Management Roles in SSRS Deployment | p. 227 |
| Managing Content | p. 228 |
| Setting Up Shared Schedules | p. 228 |
| Setting Up a Data Source for the Report | p. 234 |
| Creating Snapshots for the Report History | p. 235 |
| Executing Reports and Performing Caching | p. 238 |
| Managing Subscriptions | p. 239 |
| Performing Execution Auditing and Performance Analysis | p. 251 |
| Configuring SSRS Logging | p. 252 |
| Monitoring Performance | p. 256 |
| Controlling SSRS Programmatically | p. 258 |
| Controlling SSRS with SOAP | p. 259 |
| Controlling SSRS with WMI | p. 270 |
| Summary | p. 271 |
| Securing Reports | p. 273 |
| Encrypting Data | p. 274 |
| Introducing Encryption | p. 274 |
| Securing Network Traffic Using SSL | p. 275 |
| Setting Up Authentication and User Access to Data | p. 285 |
| Introducing SSRS Roles | p. 286 |
| Testing SSRS Role Assignments | p. 290 |
| Filtering Report Content with User!UserID | p. 295 |
| Setting Data Source Security | p. 297 |
| Setting SQL Server Permissions | p. 298 |
| Auditing Reports | p. 299 |
| Introducing SSRS Auditing | p. 299 |
| Introducing Log File Auditing | p. 300 |
| Exploring Deployment Models | p. 300 |
| Implementing SSRS with Terminal Services | p. 301 |
| Implementing for Internal Access | p. 304 |
| Summary | p. 306 |
| Delivering Business Intelligence with SSRS | p. 307 |
| Building SSRS Reports for SQL Analysis Services | p. 308 |
| Using Analysis Service Cube with SSRS | p. 312 |
| Setting Up the Analysis Services Data Source | p. 313 |
| Working with the Graphical MDX Query Builder | p. 314 |
| Incorporating SSRS with Microsoft Office SharePoint Services 2007 | p. 318 |
| Installing MOSS and SharePoint on a Stand-Alone Server | p. 319 |
| Deploying Reports in a MOSS-Integrated SSRS Installation | p. 327 |
| Creating a Simple Dashboard to Display SSRS Reports | p. 333 |
| Summary | p. 336 |
| Creating Reports Using Report Builder 1.0 and 2.0 | p. 337 |
| Getting User Feedback | p. 338 |
| Introducing the Report Model | p. 340 |
| Adding a Report Model to BIDS | p. 341 |
| Adding a Data Source | p. 342 |
| Creating a Data Source View | p. 344 |
| Creating a Report Model | p. 351 |
| Creating Reports with Report Builder 1.0 | p. 358 |
| Creating a Table Report | p. 361 |
| Creating a Matrix Report | p. 368 |
| Creating a Chart Report | p. 373 |
| Creating Reports with Report Builder 2.0 | p. 378 |
| Summary | p. 389 |
| Index | p. 391 |
| Table of Contents provided by Ingram. All Rights Reserved. |
