Table of Contents
Part I: Introduction to Reporting Services
1. Introduction to SQL Server Reporting Services (SSRS)
SSRS in the Report Development Life Cycle
Authoring Stage of the Reporting Life Cycle
Managing Stage of the Reporting Life Cycle
Delivery Stage of the Reporting Life Cycle
Editions of Reporting Services
2. Reporting Services Capabilities: Presentation, Navigation, and Programmability
Report Presentation (Rendering) Formats
Report Items, Visual Effects, and Charting
Reporting Services Data Access Features
3. Reporting Services Architecture
Report Server Web and Windows Service
Scheduling and Delivery Processor
Report Model Designer NEW in 2005
SQL Server Management Studio NEW in 2005
Reporting Services Configuration Tool NEW in 2005
RSPrintClient Control NEW in 2005
Performance Monitoring Objects
4. Reporting Services Deployment Scenarios
High-Availability Deployment Considerations
Internet Deployment Considerations
Internet Deployment Option 1: Enable Report Server for Anonymous Access
Internet Deployment Option 2: Deploy Report Server with Windows Authentication
Internet Deployment Option 3: Use the Programmatic Approach
Enabling a Report Manager for Internet Access
Key Features of SSRS by SQL Server 2005 Editions
5. Installing Reporting Services
Part II: Report Authoring from Basic to Advanced
Two Main Report Designers from Microsoft
Visual Studio Haves Versus Have Nots
Solution, Project, File Hierarchy
Generating Reports with Visual Studio
Language: A Way to Communicate
Visual Basic Runtime Functions
Using Expressions to Change Report Item Properties and Behavior
Example: Placing Emphasis on Certain Values
Data Regions, Containers, and Independent Report Items
Practical Application of Report Items
Practical Application of Chart and Matrix
Report Body Versus Page Header/Footer
12. Grouping, Sorting, and Aggregating Data, Working with Scope
Sorting, Including Interactive User Sorting
Interactive SortingNEW in 2005
Scope of an Aggregate Function
13. Advanced Report Formatting
Formatting-Related Report Item Properties
Formatting Numeric and Date/Time Values
Standard Numeric Format Strings
Standard Date/Time Format Strings
Creating Alternating Colors for the Lines on a Report
InteractiveHeight and InteractiveWidth
PageBreakAtEnd and PageBreakAtStart
Hyperlink (Jump to URL) Navigation
BookmarkLink (Jump to Bookmark) Navigation
Drillthrough (Jump to Report) Navigation
Practical Application of Action Items
15. Working with Multidimensional Data Sources
Creating a Data Mining Model (DMM)
16. Ad Hoc Reporting New in 2005
Issues Facing Ad Hoc Reporting
Client-side Reporting with SSRS
Report Models and the Model Designer
Building Reports with Report Builder
Part III: Reporting Services Administration and Operations
17. Managing Reports, Data Sources, and Models
Deployment Options in Visual Studio
Target Folder for Data SourceNEW in 1005
Building and Deploying Reports
Deployment Through Report Manager
Changing the Report ManData Source
Deploying Reports Through SQL Server Management Studio
Setting Report History and Snapshots
18. Securing Report Server Items
Reporting Services Security Model
Relationships Between Roles, Tasks, and Users
Creating/Modifying a Custom Role
Standard Versus Data-Driven Subscriptions
Overview of Delivery Extensions
Creating a Simple Subscription
Creating a Data-Driven Subscription
Deleting/Inactivating Subscriptions
20. Report Execution and Processing
Report Execution and Processing
How to Report Off the Execution Log
Creating the RSExecutionLog Database
Overview of the Sample Reports
21. Deploying and Configuring SSRS
Overview of Deployment Scenarios
Advantages/Disadvantages of the Standard Model
Advantages/Disadvantages of the Scale-Out Model
Requirements for a Standard Deployment
Requirements for a Scale-Out Deployment
Overview of Report Server Initialization
Steps to Set Up SSRS in a Scale-Out Configuration
Part IV: Developing for Reporting Services
22. Implementing Custom Embedded Functions
23. How to Create and Call a Custom Assembly from a Report
Strong-Named Custom Assemblies
.NET Security Primer for a SSRS Administrator
Assemblies That Require Other Than Execute Permissions
24. How to Integrate URL Access
How to Integrate URL Access in an Application
25. How to Use Reporting Services Web Services
Report Management Web Service New in 2005 (ReportService2005.asmx)
How to Script Reporting Services (Using the RS Utility)
Working with Report Parameters
Security When Calling a Web Service
Some of the Commonly Used Methods with Short Code Snippets
26. Writing Custom Reporting Services Extensions
Interactions Between User, SSRS, and a Delivery Extension
27. Report Rendering Controls and SharePoint Services Web Parts
Microsoft Visual Studio 2005 ReportViewer Web and Windows Controls New in 2005
Microsoft SharePoint Web Parts
28. Custom Report Definition Language (RDL) Generators and Customizing Report Definition