Pro SQL Server 2012 Reporting Services

 CONTENTS

xi

Designing the Report............................................................................................................................260

Using the Report Server Web Service...................................................................................................262

Web Services Method Categories.........................................................................................................263

Creating the GetParameters Form........................................................................................................263

Coding the Report Parameters Form....................................................................................................266

The GetParameters_Load Event...........................................................................................................266

Calling the Web Services GetItemParameters Method.........................................................................267

Rendering the Final Report...................................................................................................................271

Building the Report Viewer in ASP.NET................................................................................................274

Summary.......................................................................................................................278

 Chapter 10: Managing Reports...........................................................................279

Exploring Management Roles in SSRS Deployment......................................................279

Managing Content..........................................................................................................280

Setting Up Shared Schedules...............................................................................................................280

Creating a Shared Schedule.................................................................................................................281

Configuring a Report to Use a Shared Schedule.................................................................................. 282

Updating and Uploading the RDL File Using Report Manager..............................................................284

Setting Up a Data Source for the Report........................................................................290

Altering Report Data Sources........................................................................................292

Creating Snapshots for the Report History....................................................................293

Processing Reports and Performing Caching.......................................................................................295

Managing Subscriptions.......................................................................................................................297

Managing Standard Subscriptions.......................................................................................................298

Creating a Standard Subscription.........................................................................................................299

Configuring the Subscription................................................................................................................301

Managing Data-Driven Subscriptions...................................................................................................303

Designing the Subscription Query........................................................................................................303

Creating the Data-Driven Subscription.................................................................................................305