Table of Contents

Part I:        Introduction to Reporting Services

1      Introduction to SQL Server Reporting Services (SSRS)                5

2      Reporting Services Capabilities: Presentation, Navigation, and Programmability                                                                                    23

3      Reporting Services Architecture                                                  35

4      Reporting Services Deployment Scenarios                                  49

5      Installing Reporting Services                                                       65

Part II:       Report Authoring from Basic to Advanced                  

6      Report Designer                                                                        73

7      Report Definition Language                                                        91

8      Expressions                                                                              101
9      Accessing Data                                                                          121

10    Report Parameters                                                                    133

11    Working with Report Items                                                        141

12    Grouping, Sorting, and Aggregating Data, Working with Scope.   165

13    Advanced Report Formatting                                                     175

14    Report Navigation                                                                     193

15    Working With Multidimensional Data Sources                              205   

16    Ad Hoc Reporting ^{New in 2005}                                                        233

Part III:     Reporting Services Administration and Operations

17    Managing Reports, Data Sources, and Models                                      255

18    Securing Report Server Items                                                    275

19    Subscribing to Reports                                                               291

20    Report Execution and Processing                                                305

21    Deploying and Configuring SSRS                                       315

Part IV:      Developing for Reporting Services

22    Implementing Custom Embedded Code                                      331

23    How to Create and Call Custom Assembly from a Report           337

24    How to Use URL Access                                                            359

25    How to Use Reporting Services Web Service                              369

26     Writing Custom Reporting Services Extensions                          383

27    Report Rendering Controls and SharePoint Services Web Parts    395

28    Custom Report Definition Language (RDL) Generators and Customizing

Report Definition                                                                              401   

Part V:      Appendices

A      References and Additional Reading                                             409

B      Glossary                                                                                   411

C      FAQ                                                                                          421

Index                                                                                                425

Courses

Database Systems: Advanced Topics  [PTG: SAMS]   (Computer Science)
Database Applications - SQL Server  [KEY TRADE TITLES]   (MIS)

Author Bios

Michael Lisin has been in software industry for more than 12 years with 5 of those years with Microsoft. His primary focus is SQL Server and .NET technologies. He has been working with SQL Server for 4 years and SQL Server Reporting Services for almost 2 years starting from pre-beta in 2002. Michael has taught Reporting Services classes and presented SQL Server related topics during various events, including MSDN, SQL Server PASS and SQL Server User Group events.

Jim Joseph is a manager at Continental Airlines, Inc. He currently functions as a SQL Server DBA within the Financial Systems Group with Continental Technology. He earned his MBA at the University of St Thomas in 2003, and his undergraduate degree in mathematics from there in 1999.

Backcover Copy

SQL Server Reporting enables the creation, management, and delivery of both traditional, paper-oriented reports and interactive, Web-based reports. An integrated part of the Microsoft business intelligence framework, Reporting Services combines the data management capabilities of SQL Server and Microsoft Windows Server with familiar and powerful Microsoft Office System applications to deliver real-time information to support daily operations and drive decisions. Microsoft SQL Server 2005 Reporting Services will help you understand Reporting Services from various perspectives:

• How it fits business scenarios
• How to install and configure Reporting Services
• Reporting Services components
• Developing reports

As you progress to advanced user status, you will enjoy the chapter about accessing Reporting Services programmatically and extending Reporting Services, and you will be able to use this book as a convenient reference.

This product is a member of the following series. Click on the series name to see the full list of products in the series.

• SQL Server Series

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students contact your Pearson Higher Education representative.