SQLServer2008ReportingServicesUnleased资源-CSDN文库

SSRS

4星 · 超过85%的资源需积分: 9 119 浏览量 2010-07-17 11:14:06 上传评论 1 收藏 22.06MB PDF 举报

资源推荐

资源详情

资源评论

ptg

Microsoft

SQL

Server

™

2008

Reporting

Services

UNLEASHED

800 East 96th Street, Indianapolis, Indiana 46240 USA

Michael Lisin

Jim Joseph

Amit Goyal

From the Library of STEPHEN EISEMAN

ptg

Microsoft® SQL Server™ 2008 Reporting Services Unleashed

system, or transmitted by any means, electronic, mechanical, photocopying, recording,

or otherwise, without written permission from the publisher. No patent liability is

assumed with respect to the use of the information contained herein. Although every

precaution has been taken in the preparation of this book, the publisher and author

assume no responsibility for errors or omissions. Nor is any liability assumed for

damages resulting from the use of the information contained herein.

ISBN-13: 978-0-672-33026-1

ISBN-10: 0-672-33026-1

Library of Congress Cataloging-in-Publication data is on file.

Printed in the United States of America

First Printing July 2009

Trademarks

All terms mentioned in this book that are known to be trademarks or service marks

have been appropriately capitalized. Sams Publishing cannot attest to the accuracy of

this information. Use of a term in this book should not be regarded as affecting the

validity of any trademark or service mark.

Warning and Disclaimer

Every effort has been made to make this book as complete and as accurate as possi-

ble, but no warranty or fitness is implied. The information provided is on an “as is”

basis. The authors and the publisher shall have neither liability nor responsibility to any

person or entity with respect to any loss or damages arising from the information

contained in this book.

Bulk Sales

Pearson offers excellent discounts on this book when ordered in quantity for bulk

purchases or special sales. For more information, please contact:

U.S. Corporate and Government Sales

1-800-382-3419

corpsales@pearsontechgroup.com

For sales outside of the U.S., please contact:

International Sales

+1-317-581-3793

international@pearsontechgroup.com

Editor-in-Chief

Karen Gettman

Executive Editor

Neil Rowe

Acquisitions Editor

Brook Farling

Development Editor

Mark Renfrow

Managing Editor

Patrick Kanouse

Project Editor

Seth Kerney

Copy Editor

Keith Cline

Indexer

Ken Johnson

Proofreader

Geneil Breeze

Technical Editor

J. Boyd Nolan

Technical Contributor

Prash Shirolkar

Publishing

Coordinator

Cindy Teeters

Book Designer

Gary Adair

Composition

Mark Shirar

From the Library of STEPHEN EISEMAN

ptg

Contents at a Glance

Introduction....................................................................................................1

Part I Introduction to Reporting Services

1 Introduction to SQL Server Reporting Services (SSRS)...................................5

2 Reporting Services 2008 Architecture...........................................................23

3 Getting Started with Reporting Services Tools .............................................43

4 What's New in SQL Server Reporting Services 2008 ....................................55

5 Reporting Services Deployment Scenarios ...................................................79

6 Installing Reporting Services ........................................................................99

Part II Report Authoring from Basic to Advanced

7 Report Server Project Wizard ......................................................................111

8 Report Designer(s).......................................................................................119

9 Report Definition Language .......................................................................137

10 Expressions..................................................................................................151

11 Accessing Data ............................................................................................179

12 Report Parameters .......................................................................................197

13 Working with Report Items ........................................................................207

14 Grouping, Sorting, Aggregating Data, and Working with Scope...............251

15 Advanced Report Formatting......................................................................263

16 Report Navigation.......................................................................................283

17 Working with Multi-Dimensional Sources .................................................295

18 Ad Hoc Reporting .......................................................................................327

Part III Reporting Services Management

19 Managing Reports, Data Sources, and Models ...........................................361

20 Securing Report Server Items ......................................................................377

21 Report Execution and Processing ...............................................................389

22 Subscribing to Reports ................................................................................401

23 SSRS Administration ...................................................................................411

24 RS Utility .....................................................................................................427

Part IV Reporting Services Customizations

25 Implementing Custom Embedded Functions ............................................433

From the Library of STEPHEN EISEMAN

ptg
Table of Contents
Introduction 1
Part I Introduction to Reporting Services
1 Introduction to SQL Server Reporting Services (SSRS) 5
What Is SSRS?..................................................................................................6
SSRS for End Users ..........................................................................................6
Overview of Features.......................................................................................8
Enterprise Report Examples ............................................................................9
SSRS in the Report Development Life Cycle ................................................10
Authoring Stage ...................................................................................10
Managing Stage....................................................................................14
Delivery Stage ......................................................................................18
Editions of Reporting Services ......................................................................21
How Is SSRS Licensed? ..................................................................................21
Summary .......................................................................................................22
2 Reporting Services 2008 Architecture 23
Removal of IIS Dependency and Impact on SSRS........................................24
SSRS Windows Service ..................................................................................25
Memory Management ..................................................................................26
Programmatic Interfaces ...............................................................................29
Report Processor............................................................................................29
Command-Line Utilities ...............................................................................30
Reporting Services Extensions ......................................................................31
Data-Processing Extensions .................................................................31
Delivery Extensions .............................................................................32
Rendering Extensions ..........................................................................32
Security Extensions..............................................................................33
Report Server Databases ................................................................................33
Scheduling and Delivery Processor...............................................................34
Report Builder 1.0 .........................................................................................35
Report Model Designer .................................................................................36
Report Builder 2.0 .........................................................................................36
Report Designer.............................................................................................37
Report Manager.............................................................................................38
SQL Server Management Studio ...................................................................38
From the Library of STEPHEN EISEMAN