Microsoft SQL Server 2000... | Buy

Summary

Teach yourself how to use the components, capabilities, and programming model in SQL Server 2000 Reporting Servicesone step at a time. This practical, hands-on tutorial expertly guides you through each stage of the reporting life cycle, including authoring, managing, and delivering reports. Work at your own pace through the easy-to-follow lessons and hands-on exercises to master essential tasks and techniques. And accelerate your productivity by working with instructive code examples and best practices for SQL Server Reporting Services.Discover how to: Install and configure Reporting Services Use Report Designer to structure and format table reports Connect to data sources and datasets Use expressions to perform calculations and change properties Apply advanced techniquesfrom matrix, chart, and data regions to parameters Manage content on the Report Server, including implementing security features Monitor Report Server activity and tune for performance Access and view reports, rendered in customized formats Write and reuse custom code to author and manage reports Build your own reporting toolsAbout Reporting Services SQL Server 2000 Reporting Services is a comprehensive, server-based reporting solution to create, manage, and deploy reportson paper or over the Web. A key part of the Microsoft business intelligence framework, Reporting Services enables organizations to deliver real-time information to support daily operations and drive decisions at a lower cost of ownership.CD features: Practice files for all the book's procedures Complete eBook in PDF format

Author Biography

Hitachi Consulting, a division of Hitachi Ltd., is a global business and IT consulting firm serving Fortune 2000 companies. It is a leader in developing corporate training and custom solutions for Reporting Services

Acknowledgments	p. xiii
Introduction	p. xv
Getting Started with Reporting Services
Understanding Enterprise Reporting	p. 3
Reporting Scenarios	p. 4
Reporting User Communities	p. 6
The Enterprise Reporting Life Cycle	p. 7
Reporting Services Components	p. 9
Chapter 1 Quick Reference	p. 16
Installing Reporting Services	p. 17
Considering Deployment Options	p. 17
Preparing for Installation	p. 19
Installing Reporting Services	p. 24
Chapter 2 Quick Reference	p. 37
Building Your First Report	p. 39
Authoring a Report	p. 40
Managing a Report	p. 64
Accessing a Report	p. 74
Chapter 3 Quick Reference	p. 79
Authoring Reports
Developing Basic Reports	p. 83
Understanding a Report Definition File	p. 83
Preparing a Report by Using Report Designer	p. 84
Structuring a Report by Using Report Designer	p. 91
Formatting a Report by Using Report Designer	p. 100
Chapter 4 Quick Reference	p. 117
Working with Expressions	p. 121
Using Expressions to Calculate Values	p. 121
Using Aggregate Functions	p. 134
Using Expressions to Change an Object's Behavior	p. 141
Chapter 5 Quick Reference	p. 145
Organizing Data in Reports	p. 147
Understanding Data Regions	p. 147
Using a Matrix	p. 149
Using a Chart	p. 160
Using a List	p. 167
Chapter 6 Quick Reference	p. 172
Building Advanced Reports	p. 175
Using Parameters to Change Report Data	p. 175
Linking Information with Interactive Features	p. 194
Working with Hierarchical Data	p. 206
Chapter 7 Quick Reference	p. 217
Managing the Report Server
Managing Content	p. 223
Publishing Reports	p. 224
Organizing Content	p. 233
Using Properties to Manage Report Content	p. 243
Managing Report Execution	p. 249
Chapter 8 Quick Reference279	p. 262
Managing Security	p. 265
Using Report Server Security	p. 265
Applying Data Security	p. 279
Chapter 9 Quick Reference	p. 291
Managing Server Components	p. 293
Configuring Reporting Services	p. 293
Managing the Report Server	p. 301
Administering Reporting Services Databases	p. 322
Chapter 10 Quick Reference	p. 326
Delivering Reports
Accessing Reports	p. 331
Finding and Viewing Reports	p. 331
Saving Reports for Future Reference	p. 345
Chapter 11 Quick Reference	p. 353
Rendering Reports	p. 355
Comparing Rendering Formats	p. 355
Rendering for Online Viewing	p. 357
Rendering for Document Management	p. 363
Rendering for Data Exchange	p. 373
Chapter 12 Quick Reference	p. 381
Managing Subscriptions	p. 383
Creating a Standard Subscription	p. 383
Creating a Data-Driven Subscription	p. 397
Managing Subscriptions	p. 406
Chapter 13 Quick Reference	p. 412
Index	p. 413
Table of Contents provided by Rittenhouse. All Rights Reserved.

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.