Pro SQL Server 2012 Reporting Services

 CONTENTS

xiii

 Chapter 12: Delivering Business Intelligence with SSRS....................................361

Building SSRS Reports for SQL Analysis Services.........................................................362

Using an Analysis Service Cube with SSRS..........................................................................................367

Setting Up the Analysis Services Data Source.....................................................................................368

Working with the Graphical MDX Query Builder................................................................................... 369

Incorporating SSRS with Microsoft SharePoint 2010...........................................................................373

Installing SharePoint 2010 and SQL Server 2012 on a Stand-Alone Server..................373

Installing SharePoint 2010....................................................................................................................374

Installing SQL Server 2012 Reporting Services in SharePoint Mode....................................................375

Configuring SharePoint 2010................................................................................................................377

Installing and Starting the Reporting Services SharePoint Service......................................................379

Creating a New Reporting Services Service Application......................................................................381

Configuring Reporting Services Integration with SharePoint...............................................................384

Deploying Reports in a SharePoint-Integrated SSRS Installation..................................388

Creating a Simple Dashboard to Display SSRS Reports................................................394

Creating Data Alerts.......................................................................................................397

Summary.......................................................................................................................399

 Chapter 13: Creating Reports Using Report Builder 1.0, 2.0, and 3.0..........................401

Getting User Feedback.........................................................................................................................402

Introducing the Report Model...............................................................................................................404

Create a Report Model using BIDS 2008 R2.........................................................................................405

Adding a Data Source...........................................................................................................................406

Creating a Data Source View................................................................................................................409

Creating a Report Model.......................................................................................................................417

Creating Reports with Report Builder 1.0......................................................................423

Creating a Table Report.................................................................................................427

Creating a Matrix Report................................................................................................435