Book description
Teaches solution architects, designers, and developers how to use Microsoft's reporting platform to create reporting and business intelligence (BI) solutions
Updated with new information about holistic BI solutions, comprehensive OLAP/Analysis Services reporting, and complete production deployment scenarios
Includes programming examples focused on specific, scenario-based solutions
Explains reporting services architecture and business intelligence, teaches the fundamentals of designing reports through the use of careful planning considerations, and covers advanced report design and filtering techniques
Table of contents
- Copyright
- About the Authors
- Credits
- Acknowledgments
- Foreword by Jason Carlson
- Foreword by Thierry D'hers
- Introduction
-
I. Getting Started
-
1. Introducing Reporting Services
- 1.1. Not Your Father's Reporting Tool
- 1.2. Who Uses Reporting Services?
- 1.3. Application and Reporting Technology
- 1.4. Solution Types
- 1.5. Report Design Tools
- 1.6. Designing Reports
- 1.7. Simple Application Integration
- 1.8. Seamless Application Integration
- 1.9. Managing and Customizing the Report Server
- 1.10. Summary
- 2. Business Intelligence Solutions
- 3. Reporting Services Installation
-
4. Reporting Services Architecture
- 4.1. The Reporting Life Cycle
-
4.2. Reporting Services Tools
- 4.2.1. Report Designer
- 4.2.2. Report Builder 1.0
- 4.2.3. Report Builder 2.0
- 4.2.4. Third-Party Authoring Tools
- 4.2.5. Report Manager
- 4.2.6. SharePoint Libraries and Web Parts
- 4.2.7. Reporting Services Configuration Manager
- 4.2.8. SQL Server Management Applications
- 4.2.9. Command-Line Utilities
- 4.2.10. HTML Viewer
- 4.2.11. Report Viewer Control
-
4.3. Reporting Services Web Service
- 4.3.1. Subscriptions
- 4.3.2. Reporting Services Windows Service
- 4.3.3. HTTP.SYS and the HTTP Listener
- 4.3.4. The Security Sublayer
- 4.3.5. Report Manager and the Web Service
- 4.3.6. Core Processing
- 4.3.7. Service Management
- 4.3.8. WMI and the RPC Interface
- 4.3.9. Reporting Services Processors and Extensions
- 4.3.10. The Report Processor
- 4.3.11. Data Processing Extensions
- 4.3.12. Report Items
- 4.3.13. Rendering Extensions
- 4.3.14. The Scheduling and Delivery Processor
- 4.3.15. Delivery Extensions
- 4.4. Reporting Services Application Databases
- 4.5. Summary
-
1. Introducing Reporting Services
-
II. Report Design
-
5. Basic Report Design
- 5.1. Report Design 101
- 5.2. Report Designers
- 5.3. Report Design Elements
- 5.4. Report Definition Language
- 5.5. Report Design Elements in Detail
- 5.6. Summary
-
6. Report Layout and Formatting
- 6.1. Report Layout Types
- 6.2. Page Layout
-
6.3. Designing Tabular Reports
- 6.3.1. Defining Table Groups
- 6.3.2. Adding Totals and Subtotals
- 6.3.3. Formatting Report Data
- 6.3.4. Introduction to Dynamic Formatting
- 6.4. Designing Multicolumn Reports
- 6.5. Designing Matrix Reports
- 6.6. Designing Chart Reports
- 6.7. Designing Gauge Reports
- 6.8. Converting Reports from Other Formats and Products
- 6.9. Summary
- 7. Designing Data Access
-
8. Advanced Report Design
- 8.1. Configuring Headers and Footers
- 8.2. Creating Report Templates
- 8.3. Creating Composite Reports
- 8.4. Designing Subreports
- 8.5. Navigating Reports
- 8.6. Reporting on Recursive Relationships
- 8.7. Using Expressions and Custom Code
- 8.8. Chart Reports
- 8.9. Chart Design Basics
- 8.10. Summary
-
5. Basic Report Design
-
III. Business Intelligence Reporting
-
9. Reporting with Analysis Services
- 9.1. Why Analysis Services for Reporting?
- 9.2. Using Reporting Services with Analysis Services Data
- 9.3. Multidimensional Expression Language
- 9.4. Non-Additive Measures
- 9.5. MDX Properties and Cube Formatting
- 9.6. Drill-Through Reports
- 9.7. Best Practices and Provisions
- 9.8. Summary
-
10. Report Solution Patterns and Recipes
- 10.1. Reporting Project Requirement Guidelines
-
10.2. Report Recipes
- 10.2.1. Multiple Criterion Report Filtering
- 10.2.2. Customizing Gauges with External Images
- 10.2.3. Creating a Business Scorecard
- 10.2.4. Reporting on SharePoint 3.0 List Data
- 10.2.5. Report Localization
- 10.2.6. Dynamic Grouping
- 10.2.7. Dynamic Fields and Columns
- 10.2.8. Using Advanced and Third-Party Controls for Parameter Selection
- 10.2.9. Creating Sparklines
- 10.3. Summary
-
9. Reporting with Analysis Services
-
IV. Enabling End-User Reporting with Report Builder 1.0
- 11. Report Models
- 12. Report Builder 1.0
- V. Administering Reporting Services
-
VI. Reporting Services Integration and Custom Programming
-
15. Integrating Reports into Custom Applications
- 15.1. URL Access
- 15.2. Programmatic Rendering
- 15.3. Using the MicrosoftReportViewer Control
- 15.4. Summary
-
16. Integrating Reports with SharePoint
- 16.1. The SharePoint Technologies
- 16.2. Native Mode
- 16.3. Integrated Mode
- 16.4. Architecture
- 16.5. Native Mode versus Integrated Mode
- 16.6. Summary
-
17. Extending Reporting Services
- 17.1. Extension through Interfaces
-
17.2. Creating a Custom Data Processing Extension
- 17.2.1. The Scenario
- 17.2.2. Creating and Setting up the Project
-
17.2.3. Creating the DataSetConnection Object
- 17.2.3.1. Variable Declarations
- 17.2.3.2. Constructors
- 17.2.3.3. Implementing IDbConnectionExtension
- 17.2.3.4. Impersonate Property
- 17.2.3.5. IntegratedSecurity Property
- 17.2.3.6. UserName and Password Properties
- 17.2.3.7. Implementing IDbConnection
- 17.2.3.8. BeginTransaction Method
- 17.2.3.9. CreateCommand Method
- 17.2.3.10. Open Method
- 17.2.3.11. Close Method
- 17.2.3.12. ConnectionString Property
- 17.2.3.13. ConnectionTimeout Property
- 17.2.4. Creating the DataSetParameter Class
- 17.2.5. Implementing IDataParameter
- 17.2.6. Creating the DataSetParameterCollection Class
-
17.2.7. Creating the DataSetCommand Class
- 17.2.7.1. Variable Declarations
- 17.2.7.2. Constructors
- 17.2.7.3. Implementing IDbCommand
- 17.2.7.4. Cancel Method
- 17.2.7.5. ExecuteReader Method
- 17.2.7.6. CommandText Property
- 17.2.7.7. CommandTimeout Property
- 17.2.7.8. CommandType Property
- 17.2.7.9. CreateParameter Method
- 17.2.7.10. Parameters Property
- 17.2.8. Creating the DataReader Object
- 17.2.9. Installing the DataSetDataProcessing Extension
- 17.2.10. Testing the DataSetDataExtension
- 17.3. Summary
-
15. Integrating Reports into Custom Applications
- A. RDL Object Model
-
B. T-SQL Command Syntax Reference
-
B.1. T-SQL Commands, Clauses, and Predicates
- B.1.1. WITH
- B.1.2. SELECT
- B.1.3. SELECT TOP
- B.1.4. SELECT INTO
- B.1.5. FROM
- B.1.6. WHERE
- B.1.7. GROUP BY
- B.1.8. WITH ROLLUP
- B.1.9. BY ROLLUP
- B.1.10. WITH CUBE
- B.1.11. BY CUBE
- B.1.12. HAVING
- B.1.13. UNION
- B.1.14. EXCEPT and INTERSECT
- B.1.15. ORDER BY
- B.1.16. COMPUTE and COMPUTE BY Clauses
- B.1.17. FOR Clause
- B.1.18. OPTION Clause
- B.1.19. CASE
- B.1.20. INSERT
- B.1.21. UPDATE
- B.1.22. DELETE
- B.1.23. DECLARE @local_variable
- B.1.24. SET
- B.1.25. LIKE
- B.1.26. ALTER TABLE
- B.1.27. PIVOT Operator
- B.1.28. UNPIVOT Operator
- B.1.29. CREATE DATABASE
- B.1.30. CREATE DEFAULT
- B.1.31. CREATE PROCEDURE
- B.1.32. CREATE RULE
- B.1.33. CREATE TABLE
- B.1.34. CREATE TRIGGER
- B.1.35. CREATE VIEW
- B.1.36. CREATE SCHEMA
- B.1.37. CREATE PARTITION FUNCTION
- B.1.38. CREATE PARTITION SCHEME
- B.2. Script Comment Conventions
- B.3. Reserved Words
-
B.1. T-SQL Commands, Clauses, and Predicates
-
C. T-SQL System Variables and Functions
- C.1. System Global Variables
-
C.2. System Functions
- C.2.1. Aggregation
- C.2.2. Checksum
- C.2.3. Conversion
- C.2.4. Cryptographic
- C.2.5. Cursor
- C.2.6. Date and Time
- C.2.7. Image/Text
- C.2.8. Error Handling
- C.2.9. Mathematical
- C.2.10. Metadata
- C.2.11. Ranking
- C.2.12. Rowset
- C.2.13. Security
- C.2.14. String Manipulation
- C.2.15. System
- C.2.16. System Statistical
- D. MDX Reference
Product information
- Title: Professional Microsoft® SQL Server® 2008 Reporting Services
- Author(s):
- Release date: December 2008
- Publisher(s): Wrox
- ISBN: 9780470242018
You might also like
book
Microsoft® SQL Server™ 2008 Reporting Services Unleashed
Microsoft® SQL Server™ 2008 Reporting Services Unleashed Michael Lisin Jim Joseph Amit Goyal The authoritative, example-rich …
book
Mastering SQL Server® 2008
As Microsoft's bestselling database manager, SQL Server is highly flexible and customizable, and has excellent support—the …
book
Professional Microsoft® SQL Server® 2008 Programming
Master the increasingly complex feature set of the latest release of Microsoft SQL Server with the …
book
Beginning, Microsoft® SQL Server® 2008 Administration
SQL Server 2008 introduces many new features that will change database administration procedures; many DBAs will …