Microsoft SQL Server Reporting Services 2008

Microsoft SQL Server Reporting Services 2008

Microsoft® SQL Server™ 2008 Reporting Services Unleashed Michael Lisin Jim Joseph Amit Goyal The authoritative, example-rich guide to Microsoft’s powerful reporting platform With Microsoft SQL Server 2008 Reporting Services you can quickly deliver relevant business intelligence data wherever it’s ne...

Descripción completa

Detalles Bibliográficos
Otros Autores: Lisin, Michael Author (author), Joseph, Jim Contributor (contributor), Goyal, Amit Contributor
Formato: Libro electrónico
Idioma:Inglés
Publicado: [Place of publication not identified] Sams 2009
Edición:1st edition
Colección:Unleashed
Materias:
SQL server.
Database management > Computer programs
Relational databases > Computer programs
Corporate reports
Information retrieval
Engineering & Applied Sciences
Computer Science
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628891606719
Tabla de Contenidos:
  • Cover
  • Table of Contents
  • Introduction
  • Part I: Introduction to Reporting Services
  • 1 Introduction to SQL Server Reporting Services (SSRS)
  • What Is SSRS?
  • SSRS for End Users
  • Overview of Features
  • Enterprise Report Examples
  • SSRS in the Report Development Life Cycle
  • Editions of Reporting Services
  • How Is SSRS Licensed?
  • Summary
  • 2 Reporting Services 2008 Architecture
  • Removal of IIS Dependency and Impact on SSRS
  • SSRS Windows Service
  • Memory Management
  • Programmatic Interfaces
  • Report Processor
  • Command-Line Utilities
  • Reporting Services Extensions
  • Report Server Databases
  • Scheduling and Delivery Processor
  • Report Builder 1.0
  • Report Model Designer
  • Report Builder 2.0
  • Report Designer
  • Report Manager
  • SQL Server Management Studio
  • Reporting Services Configuration Tool
  • RSPrintClient Control
  • WMI Provider
  • Performance Monitoring Objects
  • Summary
  • 3 Getting Started with Reporting Services Tools
  • Report Manager
  • Business Intelligence Development Studio
  • Report Designer
  • Report Builder 1.0
  • Report Builder 2.0
  • Reporting Services Configuration Manager
  • SQL Server Management Studio
  • Summary
  • 4 What's New in SQL Server Reporting Services 2008
  • Report Server Architecture Changes
  • Reporting Services Configuration Manager
  • SQL Server Management Studio Updates for Administrators
  • Report Manager Update
  • Report Engine Architecture Changes
  • Report-Processing Scalability Enhancements
  • Report-Rendering Enhancements
  • ReportViewer Control Enhancements
  • Report Designer Enhancements
  • Report Builder 2.0
  • Tablix
  • Data-Visualization Controls
  • Rich-Text Support
  • RDL Enhancements
  • Teradata as a Data Source
  • SharePoint Integration Enhancements
  • Programming and API Changes
  • Upgrading from Earlier Versions
  • Summary.
  • 5 Reporting Services Deployment Scenarios
  • High-Availability Deployment Considerations
  • Overview of Deployment Scenarios
  • Requirements for a Standard Deployment
  • Requirements for a Scale-Out Deployment
  • Internet Deployment Considerations
  • Minimum Hardware Requirements
  • Software Requirements
  • Key Features of SSRS 2008 Editions
  • Licensing
  • Summary
  • 6 Installing Reporting Services
  • Summary
  • Part II: Report Authoring from Basic to Advanced
  • 7 Report Server Project Wizard
  • Sample Database Setup
  • Using the Report Server Project Wizard to Create a Simple Report
  • Summary
  • 8 Report Designer(s)
  • Three Main Report Designers from Microsoft
  • Visual Studio Haves Versus Have Nots
  • Solution, Project, File Hierarchy
  • Generating Reports with Visual Studio
  • Summary
  • 9 Report Definition Language
  • Language: A Way to Communicate
  • Use of XML
  • Declarative Programming
  • Report Elements
  • Summary
  • 10 Expressions
  • What Is an Expression?
  • Expression Syntax
  • Adding Expressions
  • Collections
  • Using Functions
  • Other Functions
  • Expression and Built-In Function Security
  • Using Expressions to Change Report Item Properties
  • Emphasizing Certain Values
  • Summary
  • 11 Accessing Data
  • Data-Processing Extensions
  • Types of Data Sources
  • Data Source Credentials
  • Connection Strings
  • Querying Data
  • Adding a Data Source
  • Summary
  • 12 Report Parameters
  • Setting Up Parameters
  • Parameter Properties
  • Data-Driven Parameters
  • Expressions with Parameters
  • Dynamic SQL with Parameters
  • Parameter Dependencies
  • Using Multivalue Parameters
  • Example of Using Multivalue Dependent Parameters
  • Summary
  • 13 Working with Report Items
  • Data Regions, Containers, and Independent Report Items
  • Report Designer's Toolbox
  • Line Report Item
  • Rectangle Report Item
  • Image Report Item.
  • Textbox Report Item (Improved in 2008)
  • Tablix (New in 2008) = Table, Matrix, List
  • Practical Application of Report Items
  • Chart Report Item (Improved in 2008)
  • Practical Application of a Chart
  • Gauge Report Item
  • Report Body Versus Page Header/Footer
  • Summary
  • 14 Grouping, Sorting, Aggregating Data, and Working with Scope
  • Grouping Data on a Report
  • Sorting, Including Interactive Sorting and Data Source Sorting
  • Scope Parameter of Aggregate Functions
  • Level and InScope Functions
  • Summary
  • 15 Advanced Report Formatting
  • Formatting-Related Report Item Properties
  • Formatting Numeric and Date/Time Values
  • Creating Alternating Colors for the Lines on a Report
  • Paging Report (Improved in 2008)
  • Summary
  • 16 Report Navigation
  • Hyperlink (Go to URL) Navigation
  • BookmarkLink (Go to Bookmark) Navigation
  • Drillthrough (Go to Report) Navigation
  • Document Map
  • Hide and Toggle Items
  • Practical Application of Action Items
  • Summary
  • 17 Working with Multidimensional Data Sources
  • Analysis Services Concepts
  • Data-Mining Concepts
  • MDX and DMX
  • Advanced OLAP Concepts
  • Creating Data-Mining Reports
  • Summary
  • 18 Ad Hoc Reporting
  • Issues Facing Ad Hoc Reporting
  • Client-Side Reporting with SSRS
  • Report Models and the Model Designer
  • Report Builder 2.0
  • Summary
  • Part III: Reporting Services Management
  • 19 Managing Reports, Data Sources, and Models
  • Deployment Options in Visual Studio
  • Deployment Through Report Manager
  • Changing Report Properties
  • Setting Report History and Snapshots
  • My Reports
  • Summary
  • 20 Securing Report Server Items
  • Reporting Services Security Model
  • Defining Custom Roles
  • Summary
  • 21 Report Execution and Processing
  • Managing Schedules
  • Report Execution and Processing
  • Report-Execution History
  • Summary
  • 22 Subscribing to Reports.
  • Overview of Subscriptions
  • Overview of Delivery Extensions
  • Creating a Simple Subscription
  • Creating a Data-Driven Subscription
  • Managing Subscriptions
  • Summary
  • 23 SSRS Administration
  • Monitoring
  • Key Management
  • Scale-Out Deployment
  • Summary
  • 24 RS Utility
  • Inside the Reporting Services Script Files
  • Command-Line Arguments
  • Sample Command Lines
  • Code Examples
  • Summary
  • Part IV: Reporting Services Customizations
  • 25 Implementing Custom Embedded Functions
  • Adding Embedded Code
  • Debugging Embedded Code
  • Summary
  • 26 Creating and Calling a Custom Assembly from a Report
  • Initializing Assembly Classes
  • Strong-Named Custom Assemblies
  • .NET Security Primer for an SSRS Administrator
  • Assemblies That Require Other Than Execute Permissions
  • Debugging Custom Assemblies
  • Summary
  • 27 Using URL Access
  • How to Control Rendering Through URL Access
  • How to Integrate URL Access in an Application
  • Summary
  • 28 Using Reporting Services Web Services
  • Report Management Web Service (ReportService2005.asmx)
  • How to Script Reporting Services (Using the RS Utility)
  • Working with Report Parameters
  • Security When Calling a Web Service (.NET 2.0 Style)
  • Security When Calling a Web Service (.NET 3.x, WCF Style)
  • Using SSL to Increase Security
  • Some of the Commonly Used Methods with Short Code Snippets
  • Summary
  • 29 Extending Reporting Services
  • Common Considerations for Custom Reporting Services Extensions: Implementation, Deployment, and Security
  • Report Definition Customization Extension
  • Delivery Extension
  • Interactions Between User, SSRS, and a Delivery Extension
  • Custom Report Items
  • Summary
  • Part V: SharePoint Integration
  • 30 Reporting Services Integration with SharePoint
  • SharePoint Technology
  • Reporting Services Integration with SharePoint.
  • Planning for SharePoint Integration
  • Unsupported Features
  • Sample Reports Integrated with SharePoint
  • Summary
  • 31 SSRS 2008 SharePoint Integration Architecture
  • Reporting Services Add-In for SharePoint
  • Summary
  • 32 Installation of Reporting Services Integrated with SharePoint
  • Installing Reporting Services
  • Installing SharePoint
  • Configuring Report Server in SharePoint Integrated Mode
  • Installing the RS Add-In for SharePoint
  • Configuring Report Server Integration via SharePoint Central Administration
  • Upgrading from SSRS2K5 SP2
  • Scaling-Out Deployments
  • Troubleshooting
  • Summary
  • 33 SharePoint Mode Administration
  • Security Overview
  • User Authentication with SharePoint
  • Windows Integrated Security
  • Trusted Account with Windows or Forms Authentication
  • User Authorization with SharePoint
  • Programmability
  • Configuration Code Sample
  • Setting Up Kerberos Authentication
  • Summary
  • 34 Tools Support for SSRS Integrated with SharePoint
  • Report Services Configuration Tool
  • SQL Server Management Studio
  • Administration and Management Pages
  • Report-Authoring Tools
  • Summary
  • 35 Viewing Reports in SharePoint
  • Report Viewer Web Part
  • Connect the Report Viewer Web Part with Other SharePoint Web Parts
  • URL Access Parameters
  • Viewing Reports with SharePoint 2.0 Web Parts
  • Summary
  • 36 Managing Reports in SharePoint
  • Managing Properties
  • Managing Permissions
  • Managing Parameters
  • Managing Report History
  • Managing Shared Schedules
  • Managing Subscriptions
  • SharePoint Document Management
  • Summary
  • 37 Ad Hoc Reporting in SharePoint
  • Report Builder Reports in SharePoint
  • Data Sources in SharePoint
  • Report Models in SharePoint
  • Report Builder 2.0
  • Tips for Report Builder Usage
  • Summary
  • Part VI: Appendixes
  • A: References and Additional Reading
  • MSDN Websites.
  • SQL Customer Advisory Team Technical Notes.

Ejemplares similares