REPORTING SERVICES AND REPORT BUILDER 3.0

MANAGEMENT AND ADMINISTRATION

•−

−

−

•−

−

−

−

−

−

MANAGEMENT AND ADMINISTRATION

MANAGEMENT AND ADMINISTRATION

MANAGEMENT AND ADMINISTRATION

Add Domain Group

or Domain User

with Site Settings

MANAGEMENT AND ADMINISTRATION

Manage Permissions

with Folder or Item

Settings

MANAGEMENT AND ADMINISTRATION

Customize Role definitions in

SQL Server Management

Studio

MANAGEMENT AND ADMINISTRATION

Manage Item

Specific Settings,

Security and other

features

MANAGEMENT AND ADMINISTRATION

Manage Item

Specific Settings

MANAGEMENT AND ADMINISTRATION

Manage Data Source

Specific Settings

http://msdn.microsoft.com/en-us/library/ms159106.aspx

REPORT DEVELOPMENT AND DEPLOYMENT

http://social.technet.microsoft.com/wiki/contents/articles/reporting-

services-samples-on-codeplex-sql-server-reporting-services-ssrs.aspx

Parameters

One or multiple

data sources from

a variety of data

sources

One or multiple

data sets from

varied data sources

Actions

One-click

Deploy

Expressions

REPORT DEVELOPMENT AND DEPLOYMENT

Edit and save existing

Reports for

Report Builder

Power Users

REPORT DEVELOPMENT AND DEPLOYMENT

Proactively distribute interactive

reports to recipient lists with

customized parameter settings

REPORT DEVELOPMENT AND DEPLOYMENT

http://archive.msdn.microsoft.com/reportviewer

http://msdn.microsoft.com/en-us/

library/aa964126(SQL.90).aspx

#sqldocum_topic4

http://www.amazon.com/

Applied-Microsoft-Server-Reporting-Services/dp/0976635313

http://blogs.microsoft.co.il/blogs/yanivy/archive/2010/08/03/create-custom-

templates-and-styles-for-ssrs-2008.aspx

http://technet.microsoft.com/en-us/library/cc966445.aspx

HIGH AVAILABILITY AND SCALABILITY

HIGH AVAILABILITY AND SCALABILITY

DATA AND REPORT ARCHIVAL

Simple to use Report Wizards

Great data visualization tools

Report Part Gallery for reusing report items

Easy drag and drop report building

Push User Defined Report

Data Level Alerts with

Defined Schedules

Define Alert

Rules

Manage User-

Defined Alerts

Stepped or Block grouping

Pivot

Custom

Subtotals

Non-pivot

columns

Nested controls Multi-Pivot

Custom

Headers

HIGHLY FLEXIBLE LAYOUT OPTIONS

Sparklines Data Bars

EXTENSIVE VISUALIZATIONS

Capitalize on Existing Reports

Reusing common report elements helps to accelerate report creation, cut down costs, and increase end-user adoption. SharePoint provides the central location for users to access a library of existing

reports and identify desired reusable content .

Report Part Gallery

ATOM

Feed

Published

Reports

Data

Sources

Encapsu-

lating

Reports

SharePoint

Farm

Report-Based

Data Feeds

SQL Server Reporting Services Data feed capabilities are provided out of the box in every report.

Microsoft Internal Only

Microsoft Internal Only

• Reset page number

for each new group

instance.

• Get current page

and total page

count for each

group, and overall