Home > Store

Microsoft SQL Server 2005 Reporting Services

Register your product to gain access to bonus material or receive a coupon.

Microsoft SQL Server 2005 Reporting Services

Premium Website

  • Sorry, this book is no longer in print.
Not for Sale


  • Copyright 2006
  • Edition: 1st
  • Premium Website
  • ISBN-10: 0-672-32799-6
  • ISBN-13: 978-0-672-32799-5

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.

Sample Content

Online Sample Chapters

Reporting Services Architecture

Reporting Services Architecture in SQL Server 2005

Downloadable Sample Chapter

Download the sample chapter

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


Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership