Hitchhiker's Guide to SQL Server 2000 Reporting Services
Read an excerpt:
Chapter 1: An Overview
Excerpt provided courtesy of Addison-Wesley Professional. Copyright © Addison-Wesley. Written permission from the publisher is required for any use of this material.
|
Customer Reviews: 2 Average Customer Rating:  Write a Review and tell the world about this title! People who purchase this book frequently purchase: - Pro SQL Server Reporting Services; Rodney Landrum, et al, $24.50, 39% Off!
- Microsoft SQL Server 2000 Reporting Services; Brian Larson, $30.50, 39% Off!
- The Guru's Guide to Transact-SQL; Ken Henderson, $40.95, 37% Off!
- Guru's Guide to SQL Server Stored Procedures, XML, and HTML; Ken Henderson, $40.95, 37% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
SQL Server 2000 Reporting Services streamlines the process of extricating meaningful
reports from SQL Server, but comes with its own challenges and pitfalls. Hitchhiker's
Guide to SQL Server 2000 Reporting Services picks up where the Microsoft documentation
leaves off. It provides database administrators, application developers, and their
managers with invaluable behind-the-scenes information on the workings of Reporting
Services.
Written on the final product release and with the direct involvement of the
Microsoft development team, this book offers an authoritative but independent
look at the technology. The authors--both Microsoft MVPs who've worked with
the technology since the beginning--reveal hidden problems and workarounds as
they steer you through each step in report installation, management, security,
creation, and programming. You can start setting up simple single-server installations
or Web farms right away while gaining an in-depth understanding of every Reporting
Services feature.
The special companion DVD includes narrated video demonstrations that show
you how to safely navigate the trickier parts of this technology. The DVD also
includes the Service Pack, Books onLine refresh kit, Reporting Services evaluation
version, code samples, and much more. A reader-only Web site provides book and
technology updates, new templates and add-ins, plus access to newsgroups, discussion
groups, and other support.
Key topic coverage includes:
- Reporting Services basics
- The Report Designer
- The Report Manager
- Security
- The Visual Studio .NET 2003 add-in for creating and deploying reports
- Solving installation, design, configuration, security, and subscription
problems
- Importing reports from Microsoft Access and other platforms
- Using the SOAP interface
- Custom Data Processing extensions
- Up-to-the-minute fixes and workarounds
Insightful, fast-paced, and fun, Hitchhiker's Guide to SQL Server 2000 Reporting
Services is your inside guide to getting the most from Reporting Services.
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.
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.
12. 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.
About the Authors
Peter Blackburn is the principal of Boost Data Limited, designing,
building, and implementing database systems based on SQL Server. He is a Microsoft
MVP who has contributed countless hours to the development of Reporting Services.
Peter supports developers worldwide through newsgroups, beta programs, and trainings
on SQL Server and Reporting Services.
William R. Vaughn is the principal of Beta V Corporation and
a Microsoft MVP who worked at Microsoft for fourteen years. His previous books
include the popular Hitchhiker's Guides (Microsoft Press) and the bestseller
ADO Examples and Best Practices (APress, 2000). Bill is a top-rated speaker
at conferences including VSLive and TechEd and is the author of numerous articles
for SQL Server Magazine, Visual Studio Magazine, and others.
Customer Reviews
Customer Reviews: 2 Average Customer Rating: Dec 29, 2005 Scott Whigham from Dallas, TX, USA
Very solid
I bought this earlier this year and just expected a nice overview on Reporting Services. I think that it goes well beyond - admin, rdl, and much more. I haven't seen a better book on SQL Server Reporting Services but, after reading this one, I didn't feel the need to look for another lol Scott Whigham - Content Manager for LearnItFirst.com
Apr 27, 2005 Stephen Szyszkiewicz from Delran, NJ
Excellent Resource
This book/cd/ and access to an optional website combine to create an excellent resource that anyone dealing with Reporting Services needs to read. The book is not a rehash of the documentation provided by Microsoft. It is a terrific top to bottom explanation of: - how to install Reporting Services - how to manage Reporting Services - How to develop for reporting Services - How to get Reporting Services to do things it doesnt do out of the box. The attendant CD gives instructions, and a live demo, on how to setup and use SSL on your development web servers. In fact the CD has loads of walkthroughs, some with voice, that provide all kinds of information you need to know to properly configure SQL Reporting Services. When SQL 2005 comes out I will buy the book these two write.
|
