Microsoft® SQL Server™ 2008 Reporting Services Unleashed

Contents at a Glance
Introduction....................................................................................................1
Part I Introduction to Reporting Services
1 Introduction to SQL Server Reporting Services (SSRS)...................................5
2 Reporting Services 2008 Architecture...........................................................23
3 Getting Started with Reporting Services Tools .............................................43
4 What's New in SQL Server Reporting Services 2008 ....................................55
5 Reporting Services Deployment Scenarios ...................................................79
6 Installing Reporting Services ........................................................................99
Part II Report Authoring from Basic to Advanced
7 Report Server Project Wizard ......................................................................111
8 Report Designer(s).......................................................................................119
9 Report Definition Language .......................................................................137
10 Expressions..................................................................................................151
11 Accessing Data ............................................................................................179
12 Report Parameters .......................................................................................197
13 Working with Report Items ........................................................................207
14 Grouping, Sorting, Aggregating Data, and Working with Scope...............251
15 Advanced Report Formatting......................................................................263
16 Report Navigation.......................................................................................283
17 Working with Multi-Dimensional Sources .................................................295
18 Ad Hoc Reporting .......................................................................................327
Part III Reporting Services Management
19 Managing Reports, Data Sources, and Models ...........................................361
20 Securing Report Server Items ......................................................................377
21 Report Execution and Processing ...............................................................389
22 Subscribing to Reports ................................................................................401
23 SSRS Administration ...................................................................................411
24 RS Utility .....................................................................................................427
Part IV Reporting Services Customizations
25 Implementing Custom Embedded Functions ............................................433

26 Creating and Calling a Custom Assembly from a Report..........................441
27 Using URL Access........................................................................................465
28 Using Reporting Services Web Services ......................................................475
29 Extending Reporting Services .....................................................................499
Part V SharePoint Integration
30 Reporting Services Integration with SharePoint ........................................519
31 SSRS 2008 SharePoint Integration Architecture .........................................527
32 Installation of Reporting Services Integrated with SharePoint..................535
33 SharePoint Mode Administration...............................................................545
34 Tools Support for SSRS Integrated with SharePoint ...................................557
35 Viewing Reports in SharePoint ...................................................................565
36 Managing Reports in SharePoint................................................................573
37 Ad Hoc Reporting in SharePoint ................................................................589
Part VI Appendixes
A References and Additional Reading............................................................597
B Glossary.......................................................................................................601
C Frequently Asked Questions and Additional Information.........................613
D What's New in SQL Server SP1?..................................................................617
E What's New in SQL Server 2008 R2? ..........................................................623
Index ...........................................................................................................624