Table of Contents
Foreword.
Preface.
Acknowledgments.
About the Authors.
1. Overview.
What is Microsoft SQL Server 2000 Reporting Services?
Summary.
2. Installing and Configuring Reporting Services.
Installation Pathways and Preparation.
Step-By-Step: Installing Reporting Services on a Server with IIS.
Installing Reporting Services in a non Default Website.
After Installation--Tuning and Reconfiguring.
Testing the Installation.
Installing Reporting Services on a Web Farm.
Removing Reporting Services.
Summary.
3. Creating Your First Report with the Report Designer Wizards.
Introduction.
Creating a Table Report with the Report Project Wizard.
Creating a Matrix Report with the Report Project Wizard.
Summary.
4. Using the Report Manager.
Understanding the Role-Based Security Mode.
Search for (Report Items).
Rendering Reports.
Creating and Managing Report Subscriptions.
Configuring the Email Interface (SMTP).
Report Item-level Security Settings.
Managing Data Sources.
Site Settings.
Summary.
5. Report Security.
Motivation.
Trojan Reports.
Data Sources.
Summary.
6. Building Data Sources and DataSets.
Data Sources and DataSets.
Preparing the Development Server and Workstation.
Building New Reports from Scratch.
Specifying and Capturing Parameters.
Advanced Techniques.
Summary.
7. Report Layout and Design.
Previewing and Deploying Reports.
Laying Out Your Report.
Working with Images.
Drilling Down into Report Data.
Using the Table control.
Advanced Tips and Techniques.
Creating Subreports.
Summary.
8. The Chart and Matrix Controls.
A Brief History of the Chart Control.
Fetching Chart Data.
Understanding the Chart Control's User Interface.
Choosing the Chart Type.
Creating a Chart.
Working with Pie and Doughnut Charts.
Annotating Charts.
Using the Stock Charts.
A Touch of Color.
Using the Bubble and Scatter Charts.
The Matrix Control.
Getting Started with the Matrix Control.
Monitoring the Report Processor.
Summary.
9. Extending Reports--Report Templates and Styles.
Building Report Wizard Style Templates.
Customizing Report and Data Source Templates.
Creating Custom DataSource Templates.
Using Code Access Security.
Summary.
10. Accessing the Report Server via URL.
Simple URL Addressing the Report Server.
Summary.
11. Customizing the Report Manager.
Simple Customizations --Tuning the CSS file and Graphics Objects.
Summary.
9¾. Managing Reports using SOAP.
Prior to Adding a Web Reference - McGonagall's Strict Admonition.
Rendering Reports with SOAP.
Summary.
13. Writing a Custom Data Processing Extension.
Building a Data Processing Extension Using the Microsoft Sample.
Writing a Report Using the File System Data Processing Extension.
Building a Data Processing Extension from Scratch.
Deploying and Configuring.
Building a Report with the EventLog Data Processing Extension.
Security Considerations for Stored Credentials.
Summary.
Appendix A. Installing SSL on a Web Server.
Appendix B. Using Secure Sockets Layer (SSL) for Reporting Services.
Appendix C. Configuring SMTP.
Appendix D. Using the IIS Metabase Editor.
Appendix E. Reporting Services Books Online.
Index.