SKIP THE SHIPPING
Use code NOSHIP during checkout to save 40% on eligible eBooks, now through January 5. Shop now.
Register your product to gain access to bonus material or receive a coupon.
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:
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.
Reporting Services Architecture
Reporting Services Architecture in SQL Server 2005
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