Microsoft SQL SERVER 2005 REPORTING SERVICES 由入门到精通 英文2025|PDF|Epub|mobi|kindle电子书版本百度云盘下载

Microsoft SQL SERVER 2005 REPORTING SERVICES 由入门到精通 英文PDF格式电子书版下载

注意：本站所有压缩包均有解压码： 点击下载压缩包解压工具

Part Ⅰ Getting Started with Reporting Services3

1 Understanding Reporting3

Reporting Scenarios3

Reporting User Communities5

The Enterprise Reporting Life Cycle6

Authoring7

Management7

Access and Delivery8

Reporting Services Components8

Authoring Components9

Management Components11

Access and Delivery Components13

Chapter 1 Quick Reference16

2 Installing Reporting Services17

Considering Deployment Options17

Choosing a Reporting Services Edition17

Planning a Site Configuration18

Deciding Naming Conventions19

Preparing for Installation19

Reviewing Operating System Requirements19

Reviewing Software Requirements20

Reviewing Configuration Prerequisites20

Creating Reporting Services Credentials21

Installing Reporting Services23

Launching Setup23

Choosing the Components24

Selecting the Service Account27

Using the Reporting Services Configuration Manager28

Configuring Virtual Directories29

Specifying the Report Server Database31

Specifying Report Delivery Options32

Verifying the Installation34

Chapter 2 Quick Reference36

3 Building Your First Report37

Authoring a Report37

Starting a New Report38

Connecting to a Data Source40

Getting Data for the Report43

Structuring Data in the Report45

Placing Data in the Report Structure46

Applying a Style Template48

Finishing the Report Wizard49

Checking the Report Layout51

Correcting Report Layout Issues55

Publishing a Report57

Managing a Report59

Reviewing Report Properties59

Changing Report Properties62

Reviewing Execution Properties63

Changing Data Sources Properties65

Changing Execution Properties66

Accessing a Report67

Displaying a Report67

Searching a Report68

Exporting a Report69

Chapter 3 Quick Reference71

Part Ⅱ Authoring Reports75

4 Developing Basic Reports75

Understandina a Report Definition File75

Preparing a Report Using Report Designer76

Creating a New Report Project76

Creating a New Report77

Connecting to a Data Source78

Working with Datasets79

Structuring a Report Using Report Designer82

Adding Items from the Toolbox82

Working with Table Rows83

Sorting Table Rows86

Grouping Data in a Table88

Adding Group Headers91

Computing Group Subtotals92

Formatting a Report Using Report Designer93

Setting the Format Property93

Applying Styles94

Editing Properties96

Adding Floating Headers98

Triggering Page Breaks100

Adding a Textbox100

Setting Table Properties103

Working with Page Headers104

Working with Page Footers105

Adding Graphical Elements106

Adding Images108

Chapter 4 Ouick Reference111

5 Working with Expressions113

Using Expressions to Calculate Values113

Creating Calculated Fields114

Using Global Variables119

Using the Reportltems Collection122

Using Aggregate Functions125

Using Aggregate Functions in a Table127

Using Aggregate Functions in a Textbox129

Using Expressions to Change an Object's Behavior132

Using Conditional Formatting132

Sorting133

Chapter 5 Quick Reference135

6 Organizing Data in Reports137

Understanding Data Regions137

Comparing Types of Data Regions137

Using Data Regions138

Using a Matrix138

Adding a Matrix Data Region139

Grouping Rows140

Sorting Rows141

Grouping Columns142

Using Subtotals in a Matrix144

Using Static Rows and Columns in a Matrix146

Using a Chart148

Adding a Chart148

Adding Values and Column Groups to a Chart149

Grouping Data by Series150

Adding a Chart Legend152

Setting Chart Properties154

Using a List155

Adding a List156

Grouping and Sorting a List157

Using Fields in a List157

Nesting Data Regions158

Chapter 6 Quick Reference160

7 Building Advanced Reports161

Using Parameters to Change Report Data161

Adding a Report Parameter162

Using the Parameters Collection164

Adding a Query Parameter167

Supplying Values for a Query Parameter169

Creating a Report Parameter for a Filter172

Adding a Filter175

Adding a Parameter Value to a Report177

Linking Information with Interactive Features177

Adding Actions179

Using the Hidden Property182

Using the Toggleltem Property183

Adding a Subreport186

Working with Hierarchical Data188

Displaying a Recursive Hierarchy in a Data Region189

Using the Level Function191

Using the Recursive Keyword192

Creating an Analysis Services Data Source and Dataset194

Using an Analysis Services Dataset196

Chapter 7 Quick Reference197

8 Building Report Models199

Understandina Report Models199

Creating a Report Model200

Adding a Report Model Data Source200

Adding a Data Source View201

Adding a Report Model204

Reviewing a Report Model207

Modifying a Report Model211

Changing Model Objects212

Organizing Model Objects215

Adding Source Fields220

Adding Expressions222

Managing a Report Model223

Publishing a Report Model224

Securing a Report Model226

Chapter 8 Quick Reference229

Part Ⅲ Managing the Report Server233

9 Managing Content233

Publishing Reports233

Defining Deployment Properties by Project234

Deploying Reports236

Uploading Reports239

Creating a Script File240

Using the rs Utility241

Organizing Content242

Working with Folders242

Moving Content244

Linking Reports246

Working with General Properties248

Using Properties to Manage Report Content250

Working with Data Sources250

Specifying a Default Value253

Disabling a Parameter Prompt255

Managing Report Execution256

Executing Reports with Current Data257

Implementing Cached Instances259

Working with Shared Schedules261

Managing Snapshots263

Using Report History266

Chapter 9 Quick Reference268

10 Managing Security271

Using Report Server Security271

Adding Role Assignments272

Applying Item Security277

Applying System Security280

Applying Data Security285

Using Roles and Parameters to Restrict Data285

Restricting the Source Query by User288

Filtering the Report Data by User293

Chapter 10 Quick Reference296

11 Managing Server Components299

Configuring Reporting Services299

Editing the rsreportserver.config File300

Changing Encrypted Configuration Information Using the rsconfig Utility302

Configuring Tracing on the Report Server305

Managing the Report Server307

How to Monitor Performance308

Managing Execution Logging308

Initializing an Execution Log Database309

Using an Execution Log Report312

Adding Current Data to the Execution Log315

Applying Time-outs to Source Queries317

Applying Time-outs to Report Execution318

Canceling Jobs320

Disabling a Shared Data Source321

Administering Reporting Services Databases324

Monitoring Database Storage Consumption324

Implementing a Backup and Restore Strategy326

Chapter 11 Quick Reference328

Part Ⅳ Delivering Reports333

12 Accessing Reports333

Finding and Viewing Reports333

Navigating the Folder Hierarchy334

Refreshing Reports336

Searching for Reports337

Using the HTML Viewer339

Using My Reports342

Saving Reports for Future Reference346

Creating a Report History Snapshot347

Saving Reports to Local Files349

Printing Reports351

Chapter 12 Quick Reference353

13 Rendering Reports355

Comparing Rendering Formats355

Rendering for Online Viewing356

Rendering as MHTML356

Rendering for Document Management358

Rendering as a TIFF File358

Rendering as a PDF File362

Rendering for Data Exchange367

Rendering as an Excel File367

Rendering a Report as a CSV File371

Rendering a Report as an XML File373

Chapter 13 Quick Reference374

14 Managing Subscriptions375

Creating a Standard Subscription375

Delivering a Report by E-Mail376

Delivering a Report to a File Share383

Creating a Data-Driven Subscription389

Creating a Subscription Delivery Table389

Creating a Data-Driven Subscription390

Managing Subscriptions398

Using the My Subscriptions Page399

Deleting Subscriptions403

Chapter 14 Quick Reference404

15 Creating Reports with Report Builder405

Building Basic Reports405

Getting Started with Report Builder405

Building a Report408

Building a Matrix Report412

Using Clickthrough415

Building a Chart Report417

Enhancing Reports420

Formatting a Report421

Filtering a Report423

Adding Expressions426

Chapter 15 Quick Reference428

Part Ⅴ Programming Reporting Services433

16 Report Authoring with Custom Development433

Using Custom Code433

Adding Custom Code to a Report434

Accessing Functions Using the Code Global Member436

Creating a Custom Class Library438

Using Functions from a Custom Assembly441

Creating Custom Data Processing Extensions446

Assigning a Namespace447

Creating a Connection Object448

Creating a Command Object450

Creating a Data Reader Object451

Deploying a Custom Data Processing Extension454

Generating Report Definition Language462

Creating a Console Application462

Adding a Data Source Connection464

Generating a Fields List465

Generating the RDL466

Chapter 16 Quick Reference469

17 Programming Report Server Management471

Understanding Web Services471

Using the rs Utility472

Querying Report Server474

Using a Custom Application to Manage Reporting Services477

Querying Report Server478

Managing Reports485

Using the Reporting Services WMI Provider493

Querying a Report Server493

Chapter 17 Quick Reference497

18 Building Custom Reporting Tools499

Using URLs499

How to Use URLs to Access Reports500

Viewing Reports500

Working with Report Parameters503

Using URL Access Parameters505

Using the Web Service510

Rendering a Report511

Authenticating Users515

Using Report Parameters in a Control517

Enabling Multiselect for Parameters524

Chapter 18 Quick Reference527

Glossary529

Index531