Sams Microsoft SQL Server 2008- P1

Chia sẻ: Thanh Cong | Ngày: | Loại File: PDF | Số trang:50

0
53
lượt xem
9
download

Sams Microsoft SQL Server 2008- P1

Mô tả tài liệu
  Download Vui lòng tải xuống để xem tài liệu đầy đủ

Với Microsoft SQL Server 2008 Reporting Services bạn có thể nhanh chóng cung cấp dữ liệu kinh doanh tình báo có liên quan của nó bất cứ nơi nào neededCacross toàn bộ doanh nghiệp, và thông qua báo cáo toàn bộ vòng đời. SQL Server 2008 Reporting Services Unleashed mang đến cho bạn tất cả các thông tin có thẩm quyền youll cần phải tận dụng tối đa của Microsolfs mạnh nhất báo cáo như là một nền tảng cơ sở dữ liệu chuyên nghiệp, quản lý, hoặc người sử dụng. Trong phạm vi bảo hiểm chuyên sâu làm cho...

Chủ đề:
Lưu

Nội dung Text: Sams Microsoft SQL Server 2008- P1

  1. Michael Lisin Jim Joseph Amit Goyal ® Microsoft SQL ™ Server 2008 Reporting Services UNLEASHED 800 East 96th Street, Indianapolis, Indiana 46240 USA lease purchase PDF Split-Merge on www.verypdf.com to remove this watermark.
  2. Microsoft® SQL Server™ 2008 Reporting Services Unleashed Editor-in-Chief Copyright © 2010 by Sams Publishing Karen Gettman All rights reserved. No part of this book shall be reproduced, stored in a retrieval Executive Editor system, or transmitted by any means, electronic, mechanical, photocopying, recording, Neil Rowe 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 Acquisitions Editor precaution has been taken in the preparation of this book, the publisher and author Brook Farling assume no responsibility for errors or omissions. Nor is any liability assumed for damages resulting from the use of the information contained herein. Development Editor Mark Renfrow ISBN-13: 978-0-672-33026-1 Managing Editor ISBN-10: 0-672-33026-1 Patrick Kanouse Library of Congress Cataloging-in-Publication data is on file. Project Editor Printed in the United States of America Seth Kerney First Printing July 2009 Copy Editor Keith Cline Trademarks Indexer All terms mentioned in this book that are known to be trademarks or service marks Ken Johnson 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 Proofreader validity of any trademark or service mark. Geneil Breeze Warning and Disclaimer Technical Editor J. Boyd Nolan 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” Technical Contributor basis. The authors and the publisher shall have neither liability nor responsibility to any Prash Shirolkar person or entity with respect to any loss or damages arising from the information contained in this book. Publishing Coordinator Bulk Sales Cindy Teeters Pearson offers excellent discounts on this book when ordered in quantity for bulk purchases or special sales. For more information, please contact: Book Designer U.S. Corporate and Government Sales Gary Adair 1-800-382-3419 corpsales@pearsontechgroup.com Composition For sales outside of the U.S., please contact: Mark Shirar International Sales +1-317-581-3793 international@pearsontechgroup.com lease purchase PDF Split-Merge on www.verypdf.com to remove this watermark.
  3. 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 lease purchase PDF Split-Merge on www.verypdf.com to remove this watermark.
  4. iv Microsoft® SQL Server™ 2008 Reporting Services 26 Creating and Calling a Custom Assembly from a Report..........................441 27 Using URL Access........................................................................................465 28 Using Reporting Services Web Services ......................................................475 29 Extending Reporting Services .....................................................................499 Part V SharePoint Integration 30 Reporting Services Integration with SharePoint ........................................519 31 SSRS 2008 SharePoint Integration Architecture .........................................527 32 Installation of Reporting Services Integrated with SharePoint..................535 33 SharePoint Mode Administration...............................................................545 34 Tools Support for SSRS Integrated with SharePoint ...................................557 35 Viewing Reports in SharePoint ...................................................................565 36 Managing Reports in SharePoint ................................................................573 37 Ad Hoc Reporting in SharePoint ................................................................589 Part VI Appendixes A References and Additional Reading............................................................597 B Glossary.......................................................................................................601 C Frequently Asked Questions and Additional Information.........................613 D What's New in SQL Server SP1?..................................................................617 E What's New in SQL Server 2008 R2? ..........................................................623 Index ...........................................................................................................624 lease purchase PDF Split-Merge on www.verypdf.com to remove this watermark.
  5. 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 lease purchase PDF Split-Merge on www.verypdf.com to remove this watermark.
  6. vi Microsoft® SQL Server™ 2008 Reporting Services Reporting Services Configuration Tool.........................................................39 RSPrintClient Control.................................................................................39 WMI Provider................................................................................................39 Performance Monitoring Objects .................................................................39 Summary .......................................................................................................40 3 Getting Started with Reporting Services Tools 43 Report Manager.............................................................................................43 Business Intelligence Development Studio ..................................................44 Report Designer.............................................................................................46 Report Builder 1.0 .........................................................................................46 Report Builder 2.0 .........................................................................................48 Reporting Services Configuration Manager .................................................50 SQL Server Management Studio ...................................................................51 Summary .......................................................................................................53 4 What’s New in SQL Server Reporting Services 2008 55 Report Server Architecture Changes .............................................................56 Reporting Services Configuration Manager .................................................58 SQL Server Management Studio Updates for Administrators ......................58 Report Manager Update ................................................................................62 Report Engine Architecture Changes ...........................................................63 Report-Processing Scalability Enhancements ...............................................65 Report-Rendering Enhancements .................................................................67 ReportViewer Control Enhancements .........................................................69 Report Designer Enhancements ...................................................................69 Report Builder 2.0 .........................................................................................69 Tablix.............................................................................................................70 Data-Visualization Controls..........................................................................71 Rich-Text Support .........................................................................................73 RDL Enhancements.......................................................................................73 Teradata as a Data Source .............................................................................74 SharePoint Integration Enhancements.........................................................74 Programming and API Changes ...................................................................75 Upgrading from Earlier Versions ..................................................................76 Summary .......................................................................................................77 5 Reporting Services Deployment Scenarios 79 High-Availability Deployment Considerations ............................................81 Overview of Deployment Scenarios .............................................................82 Advantages/Disadvantages of the Standard Model.............................83 Advantages/Disadvantages of the Scale-Out Model ...........................85 lease purchase PDF Split-Merge on www.verypdf.com to remove this watermark.
  7. Contents vii Requirements for a Standard Deployment...................................................85 Requirements for a Scale-Out Deployment..................................................86 Overview of Report Server Initialization.............................................86 Internet Deployment Considerations...........................................................87 Internet Deployment Option 1: Enable Report Server for Anonymous Access.................................................................................................88 Internet Deployment Option 2: Deploy Report Server with Windows Authentication ..................................................................................88 Internet Deployment Option 3: Use the Programmatic Approach....89 Enabling a Report Manager for Internet Access..................................90 Minimum Hardware Requirements ..............................................................91 Software Requirements .................................................................................92 Key Features of SSRS 2008 Editions ..............................................................95 Licensing .......................................................................................................97 Summary .......................................................................................................97 6 Installing Reporting Services 99 Summary .....................................................................................................109 Part II Report Authoring from Basic to Advanced 7 Report Server Project Wizard 111 Sample Database Setup ...............................................................................111 Using the Report Server Project Wizard to Create a Simple Report ..........112 Summary .....................................................................................................118 8 Report Designer(s) 119 Three Main Report Designers from Microsoft............................................119 Visual Studio Haves Versus Have Nots .......................................................121 Solution, Project, File Hierarchy.................................................................121 Generating Reports with Visual Studio ......................................................122 Design Screen.....................................................................................131 Summary .....................................................................................................135 9 Report Definition Language 137 Language: A Way to Communicate............................................................137 Use of XML .................................................................................................138 Declarative Programming ...........................................................................138 Report Elements ..........................................................................................139 Report Element..................................................................................140 ReportParameters Element ...............................................................140 DataSets Element ...........................................................................144 lease purchase PDF Split-Merge on www.verypdf.com to remove this watermark.
  8. viii Microsoft® SQL Server™ 2008 Reporting Services ReportItems Element ........................................................................148 Data Regions ......................................................................................150 Summary .....................................................................................................150 10 Expressions 151 What Is an Expression?...............................................................................151 Expression Syntax .......................................................................................152 Adding Expressions .....................................................................................155 Collections ..................................................................................................158 DataSets Collection (New in 2008) ..................................................158 DataSources Collection (New in 2008) ............................................159 Fields Collection ..............................................................................160 Globals Collection ............................................................................161 Parameters Collection.......................................................................162 ReportItems Collection.....................................................................163 User Collection ..................................................................................163 Variables Collection (New in 2008) ................................................164 Using Functions ..........................................................................................165 Visual Basic Runtime Functions ........................................................165 Aggregate Functions ..........................................................................170 Other Functions ..........................................................................................173 Expression and Built-In Function Security.................................................174 Using Expressions to Change Report Item Properties................................175 Emphasizing Certain Values .......................................................................176 Summary .....................................................................................................177 11 Accessing Data 179 Data-Processing Extensions ........................................................................180 Types of Data Sources .................................................................................180 Report-Specific Data Sources .............................................................181 Shared Data Sources...........................................................................181 Data Source Expressions ....................................................................181 Data Source Credentials..............................................................................182 Connection Strings .....................................................................................183 Querying Data.............................................................................................186 Graphical Query Designer .................................................................186 Generic Query Designer ....................................................................187 Data Set Properties.............................................................................188 Command Type .................................................................................189 Parameters..........................................................................................190 Querying XML ...................................................................................192 Fields ..................................................................................................193 lease purchase PDF Split-Merge on www.verypdf.com to remove this watermark.
  9. Contents ix Fields and XML..................................................................................194 Filters..................................................................................................195 Adding a Data Source..................................................................................195 Summary .....................................................................................................195 12 Report Parameters 197 Setting Up Parameters.................................................................................198 Parameter Properties ...................................................................................199 Data-Driven Parameters ..............................................................................200 Expressions with Parameters ......................................................................201 Dynamic SQL with Parameters...................................................................202 Parameter Dependencies.............................................................................202 Using Multivalue Parameters......................................................................203 Example of Using Multivalue Dependent Parameters ...............................203 Summary .....................................................................................................206 13 Working with Report Items 207 Data Regions, Containers, and Independent Report Items .......................208 Report Designer’s Toolbox ..........................................................................210 Line Report Item .........................................................................................211 Rectangle Report Item.................................................................................211 Image Report Item ......................................................................................211 Textbox Report Item (Improved in 2008) ..................................................214 Tablix (New in 2008) = Table, Matrix, List .................................................219 Formatting Tablix ..............................................................................230 Practical Application of Report Items.........................................................232 Chart Report Item (Improved in 2008) ......................................................235 Chart Data (Value).............................................................................236 Chart Series ........................................................................................239 Chart Category ..................................................................................240 Chart Areas ........................................................................................240 Chart’s RDL ........................................................................................241 Best Practices......................................................................................242 Practical Application of a Chart .................................................................243 Gauge Report Item .....................................................................................246 Report Body Versus Page Header/Footer ....................................................248 Summary .....................................................................................................248 14 Grouping, Sorting, Aggregating Data, and Working with Scope 251 Grouping Data on a Report ........................................................................251 Sorting, Including Interactive Sorting and Data Source Sorting ...............254 Data Source Sorting ...........................................................................254 lease purchase PDF Split-Merge on www.verypdf.com to remove this watermark.
  10. x Microsoft® SQL Server™ 2008 Reporting Services Data Region and Group Sorting ........................................................255 Interactive User Sorting .....................................................................256 Scope Parameter of Aggregate Functions...................................................258 Level and InScope Functions....................................................................260 Summary .....................................................................................................261 15 Advanced Report Formatting 263 Formatting-Related Report Item Properties................................................264 Formatting Numeric and Date/Time Values ..............................................267 Standard Numeric Format Strings .....................................................268 Custom Numeric Format Strings.......................................................270 Standard Date/Time Format Strings ..................................................272 Custom Date/Time Formatting .........................................................273 Creating Alternating Colors for the Lines on a Report..............................276 Paging Report (Improved in 2008) .............................................................277 PageHeight and PageWidth: Physical Page Sizing .............................278 InteractiveHeight and InteractiveWidth .....................................278 PageBreak (New in 2008) ..................................................................279 Columns Property: A Way to Multicolumn Reports.........................280 Advanced Group Properties: RepeatOnNewPage, KeepTogether (New in 2008), KeepWithGroup (New in 2008), and HideIfNoRows (New in 2008) .........................................................281 Summary .....................................................................................................282 16 Report Navigation 283 Hyperlink (Go to URL) Navigation ............................................................284 BookmarkLink (Go to Bookmark) Navigation............................................285 Drillthrough (Go to Report) Navigation...................................................286 Document Map ...........................................................................................287 Hide and Toggle Items ................................................................................288 Practical Application of Action Items.........................................................289 Implementation.................................................................................289 Summary .....................................................................................................294 17 Working with Multidimensional Data Sources 295 Analysis Services Concepts .........................................................................295 Data-Mining Concepts................................................................................298 Creating a Data-Mining Model .........................................................298 MDX and DMX...........................................................................................300 Advanced OLAP Concepts ..........................................................................300 Creating Data-Mining Reports....................................................................323 Summary .....................................................................................................326 lease purchase PDF Split-Merge on www.verypdf.com to remove this watermark.
  11. Contents xi 18 Ad Hoc Reporting 327 Issues Facing Ad Hoc Reporting .................................................................327 Client-Side Reporting with SSRS.................................................................328 Report Models and the Model Designer.....................................................328 Report Model Projects .......................................................................329 Model File Content............................................................................329 Features of Report Builder .................................................................339 Building Reports with Report Builder ...............................................342 Report Builder 2.0 .......................................................................................345 Report Builder 2.0 Features................................................................346 Installing Report Builder 2.0 .............................................................347 Design Surface....................................................................................348 Ribbons ..............................................................................................349 Other Dialog Boxes............................................................................350 Managing Data Sources and Data Sets ..............................................352 Report Layout ....................................................................................354 Summary .....................................................................................................359 Part III Reporting Services Management 19 Managing Reports, Data Sources, and Models 361 Deployment Options in Visual Studio .......................................................361 Server Name.......................................................................................361 Report Folder Location ......................................................................362 Overwriting Data Sources ..................................................................362 Target Folder for the Data Source......................................................362 Building and Deploying Reports .......................................................363 Deployment Through Report Manager ......................................................363 Creating a New Folder .......................................................................363 Setting Up a Data Source ...................................................................364 Uploading a Report............................................................................366 Changing the Data Source ................................................................367 Changing Report Properties........................................................................367 Basic Properties ..................................................................................367 Moving Reports..................................................................................368 Linked Reports ...................................................................................370 Setting Report History and Snapshots........................................................371 Report Server Settings to Affect Report History ................................371 Creating Snapshots ............................................................................372 Deleting Snapshots ............................................................................373 My Reports ..................................................................................................373 Enabling My Reports .........................................................................374 lease purchase PDF Split-Merge on www.verypdf.com to remove this watermark.
  12. xii Microsoft® SQL Server™ 2008 Reporting Services Disabling My Reports ........................................................................374 Summary .....................................................................................................376 20 Securing Report Server Items 377 Reporting Services Security Model .............................................................377 What Can Be Secured? ......................................................................378 How Role Assignments Work ............................................................379 Relationships Between Roles, Tasks, and Users.................................380 Overview of Built-In Roles.................................................................381 Assigning Built-In Roles.....................................................................383 Defining Custom Roles ...............................................................................386 Creating/Modifying a Custom Role ..................................................387 Summary .....................................................................................................388 21 Report Execution and Processing 389 Managing Schedules ...................................................................................389 Types of Schedules.............................................................................390 Creating/Modifying Schedules ..........................................................390 Report Execution and Processing ...............................................................392 Report-Execution Timeouts ...............................................................393 Running Processes .............................................................................394 Large Reports .....................................................................................394 Report-Execution History ...........................................................................395 What Is the Execution Log? ..............................................................395 How to Report Off the Execution Log ..............................................396 Creating the RSExecutionLog Database ............................................396 Overview of the Sample Reports .......................................................398 Summary .....................................................................................................399 22 Subscribing to Reports 401 Overview of Subscriptions ..........................................................................401 Parts of Subscriptions ........................................................................401 Uses of Subscriptions .........................................................................402 Standard Versus Data-Driven Subscriptions......................................402 Delivery Options................................................................................402 Subscription Processing .....................................................................403 Overview of Delivery Extensions ...............................................................403 Email ..................................................................................................403 Delivering to a File Share ..................................................................404 Creating a Simple Subscription ..................................................................404 File Share Delivery .............................................................................405 Creating a Data-Driven Subscription .........................................................406 lease purchase PDF Split-Merge on www.verypdf.com to remove this watermark.
  13. Contents xiii Creating a Subscriptions Database ....................................................407 Report Manager .................................................................................408 Managing Subscriptions..............................................................................408 My Subscriptions ...............................................................................409 Monitoring Subscriptions..................................................................409 Deleting/Inactivating Subscriptions..................................................410 Summary .....................................................................................................410 23 SSRS Administration 411 Monitoring ..................................................................................................411 Reporting Services Log Files ..............................................................411 Viewing and Managing Jobs..............................................................414 Performance .......................................................................................416 Configuration Items ..........................................................................418 Key Management ........................................................................................421 Backing Up the Symmetric Key.........................................................421 Restoring the Symmetric Key ............................................................422 Changing the Symmetric Key ...........................................................423 Deleting the Symmetric Key..............................................................423 Scale-Out Deployment ................................................................................424 Summary .....................................................................................................425 24 RS Utility 427 Inside the Reporting Services Script Files ...................................................427 Command-Line Arguments ........................................................................428 Sample Command Lines.............................................................................430 Code Examples............................................................................................430 Summary .....................................................................................................432 Part IV Reporting Services Customizations 25 Implementing Custom Embedded Functions 433 Adding Embedded Code .............................................................................433 Debugging Embedded Code .......................................................................437 Summary .....................................................................................................439 26 Creating and Calling a Custom Assembly from a Report 441 Initializing Assembly Classes ......................................................................446 Strong-Named Custom Assemblies.............................................................450 .NET Security Primer for an SSRS Administrator........................................450 Assemblies That Require Other Than Execute Permissions ......................457 Debugging Custom Assemblies ..................................................................460 lease purchase PDF Split-Merge on www.verypdf.com to remove this watermark. Summary .....................................................................................................474
  14. xiv Microsoft® SQL Server™ 2008 Reporting Services 27 Using URL Access 465 How to Control Rendering Through URL Access ......................................465 How to Integrate URL Access in an Application........................................472 Summary .....................................................................................................474 28 Using Reporting Services Web Services 475 Report Management Web Service (ReportService2005.asmx) ..................486 How to Script Reporting Services (Using the RS Utility) ...........................488 Working with Report Parameters................................................................489 Security When Calling a Web Service (.NET 2.0 Style)..............................491 Security When Calling a Web Service (.NET 3.x, WCF Style)....................492 Using SSL to Increase Security ....................................................................495 Some of the Commonly Used Methods with Short Code Snippets ..........496 Summary .....................................................................................................497 29 Extending Reporting Services 499 Common Considerations for Custom Reporting Services Extensions: Implementation, Deployment, and Security ...........................................503 Report Definition Customization Extension..............................................508 Limits on Customization...................................................................509 Limits on SSRS Features Supported with RDCE ................................509 Steps to Deploy and Use Your RDCE Implementation.....................510 Delivery Extension......................................................................................511 Interactions Between User, SSRS, and a Delivery Extension......................514 Custom Report Items ..................................................................................516 Summary .....................................................................................................517 Part V SharePoint Integration 30 Reporting Services Integration with SharePoint 519 SharePoint Technology ...............................................................................520 Reporting Services Integration with SharePoint ........................................521 Planning for SharePoint Integration ..........................................................522 Unsupported Features .................................................................................523 Sample Reports Integrated with SharePoint...............................................524 Summary .....................................................................................................526 31 SSRS 2008 SharePoint Integration Architecture 527 Reporting Services Add-In for SharePoint ..................................................528 Report Server Integrated Mode..........................................................529 Database Management ......................................................................530 lease purchase PDF Split-Merge on www.verypdf.com to remove this watermark.
  15. Contents xv Security Management ........................................................................531 Deployment Architecture ..................................................................532 Summary .....................................................................................................533 32 Installation of Reporting Services Integrated with SharePoint 535 Installing Reporting Services ......................................................................536 Installing SharePoint...................................................................................536 Configuring Report Server in SharePoint Integrated Mode.......................537 Installing the RS Add-In for SharePoint .....................................................538 Configuring Report Server Integration via SharePoint Central Administration..........................................................................................538 Upgrading from SSRS2K5 SP2.....................................................................542 Scaling-Out Deployments ...........................................................................542 Troubleshooting ..........................................................................................543 Summary .....................................................................................................543 33 SharePoint Mode Administration 545 Security Overview .......................................................................................545 User Authentication with SharePoint ........................................................546 Windows Integrated Security......................................................................547 Trusted Account with Windows or Forms Authentication ........................548 User Authorization with SharePoint ..........................................................549 Programmability .........................................................................................551 Configuration Code Sample .......................................................................552 Setting Up Kerberos Authentication...........................................................554 Summary .....................................................................................................555 34 Tools Support for SSRS Integrated with SharePoint 557 Report Services Configuration Tool............................................................558 SQL Server Management Studio .................................................................560 Administration and Management Pages ....................................................561 Report-Authoring Tools ..............................................................................561 Summary .....................................................................................................564 35 Viewing Reports in SharePoint 565 Report Viewer Web Part ..............................................................................566 Connect the Report Viewer Web Part with Other SharePoint Web Parts .568 URL Access Parameters................................................................................569 Viewing Reports with SharePoint 2.0 Web Parts........................................572 Summary .....................................................................................................572 lease purchase PDF Split-Merge on www.verypdf.com to remove this watermark.
  16. xvi Microsoft® SQL Server™ 2008 Reporting Services 36 Managing Reports in SharePoint 573 Managing Properties ...................................................................................574 Managing Permissions ................................................................................576 Managing Data Sources .....................................................................576 Managing Parameters..................................................................................577 Managing Report Processing Options ...............................................579 Managing Report History ...........................................................................580 Managing Shared Schedules .......................................................................580 Managing Subscriptions..............................................................................582 SharePoint Document Management ..........................................................584 Summary .....................................................................................................587 37 Ad Hoc Reporting in SharePoint 589 Report Builder Reports in SharePoint.........................................................590 Data Sources in SharePoint.........................................................................593 Report Models in SharePoint ......................................................................594 Report Builder 2.0 .......................................................................................594 Tips for Report Builder Usage .....................................................................595 Summary .....................................................................................................596 Part VI Appendixes A References and Additional Reading 597 MSDN Websites...........................................................................................597 SQL Customer Advisory Team Technical Notes .........................................597 Microsoft SQL Server 2008 Samples ...........................................................598 SQL Server Reporting Services 2008 Forum ...............................................598 Blogs ............................................................................................................598 White Papers ...............................................................................................599 SharePoint Integration Links ......................................................................599 Additional Books.........................................................................................600 B Glossary 601 C Frequently Asked Questions and Additional Information 613 D What’s New in SQL Server SP1? 617 What’s New in SP1? ....................................................................................617 E What’s New in SQL Server 2008 R2? 623 Map and Spatial Visualizations...................................................................624 Grab and Go Reporting ..............................................................................624 lease purchase PDF Split-Merge on www.verypdf.com to remove this watermark.
  17. Contents xvii Report Builder 3.0 and Ad Hoc Reporting..................................................626 SharePoint Integration Enhancements.......................................................627 Report Manager Facelift ..............................................................................627 Report Viewer Control Updates..................................................................627 ATOM Data Renderer ..................................................................................627 Other Features in R2 ...................................................................................627 lease purchase PDF Split-Merge on www.verypdf.com to remove this watermark.
  18. About the Authors Michael Lisin has been in the software industry for more than 17 years, with 10 of those years working with Microsoft. Most of his career, Michael has been consulting on SQL Server and business intelligence solutions for Microsoft’s enterprise customers. He has worked with SQL Server Reporting Services since the product’s first pre-beta version in 2002 and has taught Reporting Services classes and presented topics related to SQL Server at various events. Michael earned his MBA at Texas A&M University in 2006 and contin- ues to be a dedicated scholar of Reporting Services. He is now working with business development for Microsoft. Jim Joseph is an independent contractor with 10 years of experience developing custom software solutions in a variety of industries. He has worked with SQL Server Reporting Services since the first beta release in 2000. He earned his MBA from the University of St. Thomas in 2002. He has worked in a number of roles from developer to database adminis- trator. Amit Goyal is a senior lead manager for the SQL Server Reporting Services team at Microsoft. Before joining Microsoft, Amit was a director at Yahoo! and worked on devel- opment of the Panama search monetization platform. He has 14 years of industry experi- ence at high-tech companies such as Microsoft, Yahoo!, Oracle, and Broadbase Software. He earned his bachelor of science degree from UIUC (University of Illinois at Urbana Champaign) and master’s degree from Stanford University. lease purchase PDF Split-Merge on www.verypdf.com to remove this watermark.
  19. Dedications Michael Lisin: Dedicated to my family: my wife, Anna; my chil- dren (Helen, Noah, and Alexander); my mother; and the memory of my grandfather. Thank you all for always being extremely support- ive in my life endeavors. Jim Joseph: Dedicated to my wife, Deseere, and my son, Christopher. Thanks for having the patience to deal with an absent daddy. Amit Goyal: Dedicated to my loving parents, Mr. Ram Charan and Mrs. Manju Goyal; my wife, Meenakshi Agarwal; my daughter, Aditi; and my sister, Rashmi. Acknowledgments The authors would like to thank the publishing team for working with us on this book. Special thanks to Brook, Keith, Mark, Neil, J. Boyd, Seth, and others. Thank you for your valuable feedback, answers, and hard work on this book. Without you all, this book would not be possible. Thank you to Matt Whitten and Stephen Rauch for getting Michael started with Reporting Services and to Dr. John Groth of Texas A&M for instilling creativity in your students. Thank you to Kevin Swailes for pointers about exception reports. Amit Goyal would like to thank his colleagues on the SQL Server Reporting Services team for help with content from their areas of expertise, especially Prash Shirolkar, Lukasz Pawlowski, Neeraja Divakaruni, Robert Bruckner, Nico Cristache, and Sean Boon. lease purchase PDF Split-Merge on www.verypdf.com to remove this watermark.
  20. We Want to Hear from You! As the reader of this book, you are our most important critic and commentator. We value your opinion and want to know what we’re doing right, what we could do better, what areas you’d like to see us publish in, and any other words of wisdom you’re willing to pass our way. You can email or write me directly to let me know what you did or didn’t like about this book—as well as what we can do to make our books stronger. Please note that I cannot help you with technical problems related to the topic of this book, and that due to the high volume of mail I receive, I might not be able to reply to every message. When you write, please be sure to include this book’s title and authors as well as your name and phone or email address. I will carefully review your comments and share them with the author and editors who worked on the book. Email: feedback@samspublishing.com Mail: Neil Rowe Executive Editor Sams Publishing 800 East 96th Street Indianapolis, IN 46240 USA Reader Services Visit our website and register this book at www.informit.com/title/9780672330261 for convenient access to any updates, downloads, or errata that might be available for this book. lease purchase PDF Split-Merge on www.verypdf.com to remove this watermark.
Đồng bộ tài khoản