Microsoft SQL Server 2005 Reporting Services
Published on 30. March 2006
Book
Paperback/Softback
480 pages
978-0-672-32799-5 (ISBN)
Description
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.
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.
More details
Language
English
Place of publication
Indianapolis
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 178 mm
Width: 235 mm
Thickness: 27 mm
Weight
735 gr
ISBN-13
978-0-672-32799-5 (9780672327995)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
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.
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.
Content
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
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