Cover image for Applied Microsoft SQL Server 2008 Reporting Services.
Applied Microsoft SQL Server 2008 Reporting Services.
Title:
Applied Microsoft SQL Server 2008 Reporting Services.
Author:
Lachev, Teo.
ISBN:
9780976635321
Personal Author:
Physical Description:
1 online resource (770 pages)
Contents:
Cover -- contents -- preface -- acknowledgements -- about the book -- source code -- about the author -- PART 1: INTRODUCTION -- Chapter 1: Introducing Reporting Services -- 1.1 Understanding Reporting Services -- 1.1.1 Understanding Reporting Services Reports -- 1.1.2 Why Use Reporting Services? -- 1.1.3 A Short History of Reporting Services -- 1.1.4 What's New in Reporting Services 2008 -- 1.1.5 Reporting Services and the Microsoft Business Intelligence Platform -- 1.2 Overview of Reporting Services -- 1.2.1 Understanding the Reporting Services Components -- 1.2.2 Report Authoring -- 1.2.3 Report Management -- 1.2.4 Report Delivery -- 1.3 The Reporting Services Architecture -- 1.3.1 Understanding the Report Server Hosting Model -- 1.3.2 Understanding the Reporting Services Applications -- 1.3.3 Understanding Report Processing -- 1.4 Applied Reporting Services -- 1.4.1 Introducing Adventure Works Sales Reporting System -- 1.4.2 Your First Report (Demo) -- 1.5 Summary -- 1.6 Resources -- Chapter 2: Installing Reporting Services -- 2.1 Planning for a Reporting Services Installation -- 2.1.1 Planning Hardware and Software -- 2.1.2 Planning a Deployment Topology -- 2.1.3 Planning Service Accounts -- 2.2 Performing a New Installation -- 2.2.1 Performing Initial Setup Steps -- 2.2.2 Installing a New SQL Server Installation -- 2.3 Upgrading Reporting Services -- 2.3.1 Planning the Upgrade Process -- 2.3.2 Working with the SQL Server 2008 Upgrade Advisor -- 2.3.3 Upgrading a Reporting Services Installation -- 2.4 Performing Initial Configuration -- 2.4.1 Testing the Reporting Services Installation -- 2.4.2 Configuring Reporting Services URLs -- 2.4.3 Performing Additional Configuration Steps -- 2.5 Summary -- 2.6 Resources -- PART 2: THE REPORT DESIGNER -- Chapter 3: Report Design Fundamentals -- 3.1 Designing for Report Design.

3.1.1 Understanding the Report Authoring Cycle -- 3.1.2 Understanding Report Designers -- 3.2 Working with Report Server Projects -- 3.2.1 Business Intelligence Development Studio vs. Visual Studio -- 3.2.2 Performing Project Tasks -- 3.3 Authoring a Basic Report -- 3.3.1 Getting Started in Report Designer -- 3.3.2 Working with Data (Demo) -- 3.3.3 Working with Report Parameters (Demo) -- 3.3.4 Understanding Report Items -- 3.3.5 Understanding Expressions -- 3.3.6 Understanding Collections -- 3.3.7 Understanding Functions -- 3.3.8 The Anatomy of a Textbox -- 3.3.9 Designing the Report Layout (Demo) -- 3.4 Auto-generating Report Definitions -- 3.4.1 Using the Report Wizard (Demo) -- 3.4.2 Importing Reports from Microsoft Access -- 3.5 Summary -- 3.6 Resources -- Chapter 4: Designing Data Access -- 4.1 Understanding Data Access -- 4.1.1 Understanding Data Architecture -- 4.1.2 Understanding Data Providers -- 4.2 Connecting to Data -- 4.2.1 Working with Shared Data Sources -- 4.2.2 Working with Report-Specific Data Sources -- 4.2.3 Using Transactions -- 4.3 Working with Datasets -- 4.3.1 Understanding the Dataset Definition -- 4.3.2 Using the Generic Query Designer -- 4.3.3 Using the Graphical Query Designer -- 4.3.4 Filtering Datasets -- 4.3.5 Working with Stored Procedures -- 4.4 Working with Report Parameters -- 4.4.1 Understanding Report Parameters -- 4.4.2 Designing a Parameterized Report -- 4.4.3 Securing Reports with Parameters -- 4.5 Working with Other Data Sources -- 4.5.1 Using Microsoft Access Databases -- 4.5.2 Working with XML Data -- 4.5.3 Retrieving Data from Integration Services -- 4.5.4 Using a .NET Framework Data Provider -- 4.6 Summary -- 4.7 Resources -- Chapter 5: Designing Tablix Reports -- 5.1 Designing Tabular Reports -- 5.1.1 The Anatomy of a Table Region -- 5.1.2 Designing a Stepped Report (Demo).

5.1.3 Working with Advanced Grouping Options -- 5.1.4 Implementing a Balance Sheet Report -- 5.2 Designing Crosstab Reports -- 5.2.1 The Anatomy of the Matrix Region -- 5.2.2 Working with Dynamic Column Groups (Demo) -- 5.2.3 Working with Static Groups and Totals (Demo) -- 5.2.4 Implementing Adjacent Groups (Demo) -- 5.3 Designing Freeform Reports -- 5.3.1 The Anatomy of the List Region -- 5.3.2 Designing a Freeform Layout (Demo) -- 5.3.3 Working with Subreports -- 5.3.4 Implementing Multicolumn Reports -- 5.4 Implementing Interactive Reports -- 5.4.1 Understanding Report Interactivity -- 5.4.2 Implementing Toggled Visibility -- 5.4.3 Implementing Hyperlink Actions -- 5.4.4 Implementing Interactive Sorting -- 5.4.5 Implementing a Document Map -- 5.5 Summary -- 5.6 Resources -- Chapter 6: Designing for Data Visualization -- 6.1 Designing Chart Reports -- 6.1.1 Understanding the Chart Region -- 6.1.2 The Anatomy of a Chart Region -- 6.1.3 Designing a Column Chart (Demo) -- 6.1.4 Designing a Line Chart (Demo) -- 6.2 Working with Chart Types -- 6.2.1 Histogram Charts -- 6.2.2 Pareto Charts -- 6.2.3 Three-Dimensional Column Charts -- 6.2.4 Bar Charts -- 6.2.5 Shape Charts -- 6.2.6 Area Charts -- 6.2.7 Range Charts -- 6.2.8 Scatter Charts -- 6.2.9 Polar Charts -- 6.3 Designing Gauge Reports -- 6.3.1 Understanding the Gauge Region -- 6.3.2 Implementing a Radial Gauge (Demo) -- 6.3.3 Implementing a Linear Gauge -- 6.3.4 Combining Charts and Gauges -- 6.3.5 Implementing Sparklines -- 6.4 Summary -- 6.5 Resources -- Chapter 7: Advanced Report Design -- 7.1 Designing For Rich Formatting -- 7.1.1 Understanding Rich Formatting -- 7.1.2 Implementing Mail Merge Reports -- 7.2 Designing For Report Output -- 7.2.1 Understanding Report Renderers -- 7.2.2 Working with Report Renderers -- 7.3 Extending Reports with Custom Code -- 7.3.1 Understanding Custom Code.

7.3.2 Working with Embedded Code -- 7.3.3 Working with External Code -- 7.3.4 Securing Custom Code -- 7.3.5 Debugging Custom Code -- 7.4 Report Design Challenges and Solutions -- 7.4.1 Working with Variables -- 7.4.2 Working with External Images -- 7.4.3 Passing Multivalued Parameters to Stored Procedures -- 7.4.4 Localizing Reports -- 7.4.5 Generating RDL Programmatically -- 7.5 Summary -- 7.6 Resources -- PART 3: THE REPORT BUILDER -- Chapter 8: Building Report Models -- 8.1 Understanding Report Builder 1.0 -- 8.1.1 The Report Builder Architecture -- 8.1.2 Understanding Report Models -- 8.1.3 Comparing Report Models and UDM -- 8.2 Implementing Report Models -- 8.2.1 Working with Data -- 8.2.2 Generating the Raw Model -- 8.3 Refining Report Models -- 8.3.1 Working with Entities and Fields -- 8.3.2 Advanced Report Modeling -- 8.3.3 Dealing with Changes -- 8.3.4 Deploying Report Models -- 8.4 Working with Analysis Services Models -- 8.4.1 Generating Report Models from Analysis Services -- 8.4.2 Understanding Analysis Services Limitations -- 8.5 Summary -- 8.6 Resources -- Chapter 9: Authoring Ad Hoc Reports -- 9.1 Understanding Report Builder 1.0 Client -- 9.1.1 Understanding Features -- 9.1.2 Deploying Report Builder 1.0 Client -- 9.2 Designing Ad Hoc Reports -- 9.2.1 Authoring Table Reports -- 9.2.2 Authoring Matrix Reports -- 9.2.3 Designing Chart Reports -- 9.2.4 Authoring OLAP Reports -- 9.3 Advanced Ad Hoc Reporting -- 9.3.1 Working with Filters and Formulas -- 9.3.2 Working with Report Model Data Sources -- 9.3.3 Implementing Custom Drillthrough Reports -- 9.3.4 Capturing Native Queries -- 9.4 Securing Report Builder Models -- 9.4.1 Granting Report Builder Access -- 9.4.2 Implementing Model Item Security -- 9.4.3 Implementing Data Security -- 9.5 Summary -- 9.6 Resources -- Chapter 10: Previewing Report Builder 2.0.

10.1 Understanding Report Builder 2.0 -- 10.1.1 Introducing Report Builder 2.0 Environment -- 10.1.2 Understanding Report Builder 2.0 Features -- 10.2 Authoring an OLAP Report -- 10.2.1 Getting Started with Report Builder 2.0 -- 10.2.2 Configuring the Report Data -- 10.2.3 Designing the Report -- 10.3 Authoring a Relational Report -- 10.3.1 Configuring the Report Data -- 10.3.2 Designing the Report Layout -- 10.4 Summary -- 10.5 Resources -- PART 4: MANAGEMENT -- Chapter 11: Management Fundamentals -- 11.1 Understanding Report Management -- 11.1.1 Understanding Report Management Tools -- 11.1.2 Understanding the Report Server Service -- 11.1.3 Managing the Report Server -- 11.2 Managing Report Server Content -- 11.2.1 Understanding Report Server Content -- 11.2.2 Managing Folders -- 11.2.3 Managing Data Sources -- 11.2.4 Managing Reports -- 11.3 Managing Security -- 11.3.1 Understanding Report Server Security -- 11.3.2 Granting Administrator Access -- 11.3.3 Granting User Access -- 11.3.4 Viewing Security Policies -- 11.4 Summary -- 11.5 Resources -- Chapter 12: Managing Report Execution and Subscriptions -- 12.1 Managing Report Execution -- 12.1.1 Understanding Report Execution Options -- 12.1.2 Managing Execution Sessions -- 12.1.3 Managing Cache Snapshots -- 12.1.4 Managing Execution Snapshots -- 12.1.5 Managing Report Execution Timeouts -- 12.2 Managing Subscriptions -- 12.2.1 Understanding Subscriptions -- 12.2.2 Managing Standard Subscriptions -- 12.2.3 Managing Data-Driven Subscriptions -- 12.3 Summary -- 12.4 Resources -- Chapter 13: Advanced Report Management -- 13.1 Programming Report Management -- 13.1.1 Understanding the Management API -- 13.1.2 Tracing Web Methods -- 13.1.3 Programming Management Tasks -- 13.1.4 Scripting Management Tasks -- 13.1.5 Using the WMI Provider -- 13.2 Monitoring Reporting Services.

13.2.1 Understanding the Reporting Services Log Files.
Abstract:
Supplying much-needed technological information to workers, administrators, and developers, this guide book shows how to design feature-rich standard and ad hoc reports on the Microsoft SQL server. The reference gives administrators the necessary background to install, upgrade, and manage the SQL report environment, and the techniques help developers extend reporting services to integrate with a wide range of applications for building complete business solutions. Programmers will be able to enterprise data into meaningful reports that can be shared easily with coworkers, customers, and partners—increasing company-wide communication, data interrelation, and, ultimately, creating a more profitable business.
Local Note:
Electronic reproduction. Ann Arbor, Michigan : ProQuest Ebook Central, 2017. Available via World Wide Web. Access may be limited to ProQuest Ebook Central affiliated libraries.
Electronic Access:
Click to View
Holds: Copies: