Microsoft SQL Server Reporting Services 2008

Format:

Book

Author/Creator:

Lisin, Michael, Author.

Contributor:

Joseph, Jim, Contributor.

Goyal, Amit, Contributor.

Series:

Unleashed

Language:

English

Subjects (All):

SQL server.

Database management--Computer programs.

Database management.

Relational databases--Computer programs.

Relational databases.

Corporation reports.

Information retrieval.

Physical Description:

1 online resource (xvii, 661 p.) : ill.

Edition:

1st edition

Other Title:

SQL server 2008 reporting services unleashed

Place of Publication:

[Place of publication not identified] Sams 2009

Language Note:

English

System Details:

text file

Summary:

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 needed–across the entire enterprise, and through the entire reporting lifecycle. SQL Server 2008 Reporting Services Unleashed gives you all the authoritative information you’ll need to make the most of Microsoft’s most powerful reporting platform as a database professional, manager, or user. In-depth coverage makes this book an ideal reference, and its extensive set of practical examples help you address virtually any challenge in deployment, configuration, administration, or report building. The authors have extensively expanded this edition with deeper reference information, many more practical examples, and insider perspective into Reporting Services 2008’s powerful new enhancements. You’ll discover how to take full advantage of Reporting Services’ significant architectural changes, its flexible new Tablix control, improved visualization through charts and gauges, deep SharePoint integration through SharePoint Integrated Mode, new output presentation formats, and much more. Understand how to Learn about the new features of Service Pack 1 (SP1) and the SQL Server 2008 R2 release Quickly take advantage of Microsoft’s newest SQL Server Reporting Services enhancements Use Reporting Services to identify trends and solve real business problems Master report authoring–from basic, wizard-driven techniques to the cutting edge Group, sort, and aggregate data, and define the right scope for your information Utilize advanced report formatting techniques Work effectively with multidimensional sources Manage report data sources and models Secure reports against attacks and intrusions Customize Reporting Services with embedded functions, custom assemblies, URL access, Web Services, and other extensions Thoroughly integrate SQL Server reporting into any SharePoint site Michael Lisin, lead author of Microsoft SQL Server 2005 Reporting Services , has years of field experience working with SQL Server Reporting Services at Microsoft and delivering solutions for Microsoft’s enterprise customers. Jim Joseph, co-author of Microsoft SQL Server 2005 Reporting Services Unleashed , is an independent contractor with 10 years experience developing custom software solutions in ...

Contents:

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

3 Getting Started with Reporting Services Tools

Business Intelligence Development Studio

Reporting Services Configuration Manager

4 What's New in SQL Server Reporting Services 2008

Report Server Architecture Changes

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

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

6 Installing Reporting Services

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

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

9 Report Definition Language

Language: A Way to Communicate

Use of XML

Declarative Programming

Report Elements

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

11 Accessing Data

Data-Processing Extensions

Types of Data Sources

Data Source Credentials

Connection Strings

Querying Data

Adding a Data Source

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

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

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

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)

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

17 Working with Multidimensional Data Sources

Analysis Services Concepts

Data-Mining Concepts

MDX and DMX

Advanced OLAP Concepts

Creating Data-Mining Reports

18 Ad Hoc Reporting

Issues Facing Ad Hoc Reporting

Client-Side Reporting with SSRS

Report Models and the Model Designer

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

20 Securing Report Server Items

Reporting Services Security Model

Defining Custom Roles

21 Report Execution and Processing

Managing Schedules

Report Execution and Processing

Report-Execution History

22 Subscribing to Reports.

Overview of Subscriptions

Overview of Delivery Extensions

Creating a Simple Subscription

Creating a Data-Driven Subscription

Managing Subscriptions

23 SSRS Administration

Monitoring

Key Management

Scale-Out Deployment

24 RS Utility

Inside the Reporting Services Script Files

Command-Line Arguments

Sample Command Lines

Code Examples

Part IV: Reporting Services Customizations

25 Implementing Custom Embedded Functions

Adding Embedded Code

Debugging Embedded Code

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

27 Using URL Access

How to Control Rendering Through URL Access

How to Integrate URL Access in an Application

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

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

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

31 SSRS 2008 SharePoint Integration Architecture

Reporting Services Add-In for SharePoint

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

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

34 Tools Support for SSRS Integrated with SharePoint

Report Services Configuration Tool

Administration and Management Pages

Report-Authoring Tools

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

36 Managing Reports in SharePoint

Managing Properties

Managing Permissions

Managing Parameters

Managing Report History

Managing Shared Schedules

SharePoint Document Management

37 Ad Hoc Reporting in SharePoint

Report Builder Reports in SharePoint

Data Sources in SharePoint

Report Models in SharePoint

Tips for Report Builder Usage

Part VI: Appendixes

A: References and Additional Reading

MSDN Websites.

SQL Customer Advisory Team Technical Notes.

Notes:

Bibliographic Level Mode of Issuance: Monograph

Description based on publisher supplied metadata and other sources.

ISBN:

9786612433399

9780768689167

0768689163

9781282433397

1282433393

9780768689143

0768689147

OCLC:

1027186521