Microsoft SQL Server 2000 Reporting Services (Database) (Paperback)

~ (Author) "SQL Server 2000 Reporting Services is Microsoft's entry into the web-based reporting arena..." (more)
Key Phrases: report layout area, image report item, custom security extension, Reporting Services, Visual Studio, Galactic Delivery Services (more...)

Editorial Reviews

Product Description

This terrific tome shows you how to use Microsoft's powerful new reporting technology to build reports from virtually any datasource! Using more than 60 practical, re-usable report and code samples to demonstrate the power of SQL Server Reporting Services, the author covers administration as well as implementation of SQL Server Reporting Services, including how to get the maximum time and effort benefit from these tools.

From the Publisher

Transform your company's valuable data into easily shared information with help from this definitive resource. Written by a member of the Reporting Services development team, this hands-on guide covers everything from installation to administration and shows you how to create visually appealing reports with ease and accuracy. You'll get a firm understanding of the entire report-building process by following a case study throughout the course of the book. Learn first-hand how to extract data using the Query Builder and master key tools such as the Report Wizard and Report Manager. Leverage the power of Microsoft's most powerful server-based reporting solution to improve business decision-making and facilitate company-wide, even worldwide, communication.

This book covers all aspects of Reporting Services from designing your Reporting Services installation to deploying your reports and configuring their security and execution parameters. There is something for all levels of user, from the novice (basics of database querying and report design) to advanced (incorporating .NET assemblies into a report and a detailed example of the implementation of a custom security extension).

See all Editorial Reviews

Product Details

• Paperback: 704 pages
• Publisher: McGraw-Hill Osborne Media; 1 edition (May 21, 2004)
• Language: English
• ISBN-10: 0072232161
• ISBN-13: 978-0072232165
• Product Dimensions: 8.9 x 7.4 x 1.4 inches
• Shipping Weight: 2.4 pounds
• Average Customer Review: 3.5 out of 5 stars  See all reviews (15 customer reviews)
• Amazon.com Sales Rank: #637,604 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

14 of 14 people found the following review helpful:

3.0 out of 5 stars Good book, but could have been better, October 3, 2004

By	ueberhund "ueberhund" (Salt Lake City, UT United States) - See all my reviews

SQL Server reporting services are a relatively new feature of SQL Server 2000, so I was quite excited to pick up a copy of this book. While this is a good beginning book for learning SQL and the basics of SQL Server reporting services, I have to say that I was a bit disappointed in both the presentation and depth of content this book provides. Again, this book provides some good explanation, however, the reader should be prepared for an introductory book, certainly not an advanced text.

The first section of the book provides a very good introduction to SQL and SQL Server. However, this is still very introductory information, and will only be useful for very beginning readers. In fact, the author doesn't begin discussing the books topic until page 161. Again, this introductory information is quite necessary to understand the rest of the text, I was just hoping for a more abbreviated version of the introductory material.

The rest of the book is actually much better and much more met my expectations. The author then proceeds to discuss how to generate reports. While much of the work involved in creating reports with SQL reporting services involves the use of a wizard, the author does a good job demonstrating how to expand reports beyond the default. The last section of the book goes through many of the more advanced options found in reporting services. There is a good discussion on exporting reports to different formats (including PDF, TIFF, and CSV). The final two chapters of the book are excellent, which discuss such advanced options as configuring subscriptions for reporting services and ASP.NET Code Access Security (CAS).

This is really a good book, it's just not as advanced as I was hoping for. While it's certainly a valuable resource for anyone working on SQL Server reporting services, it would have been preferable if the introductory content wasn't quite as extensive. In spite of this complaint, I would still recommend it.

6 of 6 people found the following review helpful:

5.0 out of 5 stars This is the SQL RS Guide, April 3, 2005

By	DBL (Hattiesburg, MS USA) - See all my reviews

Amazon Verified Purchase

I started reading this book when first toying with Reporting Services. I found another book that I thought did a better job. However, when I was actually having to professionally use Reporting Services and produce results, I had totally different questions and found my way back to this book. It was amazing how each question that I had was now being answered simplistically and accurately allowing me to satisfy my client and learn a new tool. This is the book to use to bring the power of Reporting Services to life.

6 of 6 people found the following review helpful:

5.0 out of 5 stars A guide for newbies and veterans alike, June 15, 2004

By	"shane_sargent" (St. Louis Park, MN United States) - See all my reviews

I found Microsoft SQL Server 2000 Reporting Services by Brian Larson to be both entertaining and highly informative. The three main attributes that I like were the assumed knowledge level of the reader, the order in which Mr. Larson worked through the examples he provided, and the business need paradigm which frames the whole book.

Microsoft SQL Server 2000 Reporting Services assumes very little knowledge on the part of the reader, but manages to provide explanations and detail procedures in a manner that doesn't belittle the novice nor frustrate the more advanced user. Mr. Larson avoids the trap into which many other technical writers have fallen: abandoning the novice as the book advances. As the complexity of the examples increases, so does the assumed knowledge base of the user, but there is always a well defined trail of bread crumbs leading the novice back to the appropriate spot in the book where the skill was originally explained.

Microsoft SQL Server 2000 Reporting Services works through concepts in a way that I found effective. First, Mr. Larson tells us what Reporting Services features are to be explored. Next, the business/reporting need is explained, followed by an overview of how the reader will meet that need. We then work through a task list with detailed, step-by-step instructions including images and screenshots. This is accomplished both within the confines of the friendly Visual Studio wizards, and without the wizard so the reader is exposed to what's happening behind the scenes. Finally, Mr. Larson provides the reader with further context and explanations for why tasks were necessary or why they were performed in the manner and order in which they were performed.

Finally, the entire book is framed by a desire to meet the business needs of a fictitious shipping company. Though the business and business model are highly entertaining, and I caught myself laughing aloud on several occasions, the needs of its employees are much the same as any terrestrial, real world company. Because of this, the reader stays grounded, and is led to think of ways to apply the examples, and the skills or features they illustrate, to their own business environment. In my opinion, it is this aspect of Microsoft SQL Server 2000 Reporting Services that is the most valuable.