ssrs introduction session 1

Microsoft SQL Server Reporting Services

MuthuvelAssociate ConsultantFlextronics

SSRS Roadmap

IntroductionReporting Service ArchitectureHow Report Publishing & Management WorksHow Report Execution WorksSSRS ComponentsTypes of SSRS ReportsDevelopment/AuthoringDeploymentDemo

Microsoft Business Intelligence

Business Productivity Suite

Business Collaboration Platform

Information Platform

Microsoft Business Intelligence

Business Productivity Suite

Business Collaboration Platform

Information Platform

Report Server

SQL Server Catalog

Report Engine

Scheduling & DeliveryRendering

Data Processing Security Delivery Targets(E-mail, SharePoint, Custom)

Security Services

Output Formats

Data Sources

RDCE

Customized RDL

Custom Report ItemCustom Visualization

SSMSReport Viewer

Web Service Proxy

Report Viewer Web Part

SharePoint

Web Services & URL Access

Reporting Services Architecture

Client Application Report Server

PublishingCreateReport

RDL

Compiled Definition

Managed Properties

Report Catalog

RDL

Compiled Definition

Managed Properties

RDL

Reporting Services 101How Report Publishing & Management Works

Client Application Report Server Report Catalog

Reporting Services 101 How Report Execution Works

RSDB

Report Metadata

RDL

Compiled Definition

Managed Properties

Client Application Report Server Report Catalog

Reporting Services 101 How Report Execution Works

RSDB

RSTempDB

Report Metadata

Session

Session

Compiled Definition

“Get & Run Report”

Execution Snapshot

Report Data

Report Data

Word/Excel/HTML/PDF

SSRS Components

Data Sources ... Microsoft SQL Server Microsoft SQL Server Analysis Services Microsoft Access OLE DB ODBC Oracle XML

SSRS Components

Data Sets ... Mapping of Report Fields to Data Source Query Definition Result Set Schema

SSRS Components

Reports ... Tabular Matrix / Crosstab / Pivot Charts / Graphs Report Definition Language (RDL)

SSRS Components

Output Formats ... HTML Excel CSV PDF XML Word TIFF File MHTML (Web Archive) Custom

SSRS Components

Delivery Targets ... E-mail File Share Custom

SSRS Components

Meta Data Database ... Reports and Data Sources Users and Permissions Scheduling and Distribution

With Reporting Services, we can create following types of reports:

Parameterized reports - used for filtering reports data Linked reports - provides an access to an existing report Snapshot reports - query results that were retrieved at a

specific time Cached reports - saved copy of a processed report Ad hoc reports - created from an existing Report Model Drilldown reports - initially hide complexity and enable the user to toggle conditionally Drillthrough reports - accessed through a hyperlink on a report item

in the original report Subreports - displays another report inside the body of a main report

Report Development / Authoring

Create RS Project Visual Studio 2005 SQL Server BI Development Studio

Create Report Data Source Query Fields / Layout

Preview View Code (in XML) Deploy

Report Development / Authoring

Create RS Project Open Visual Studio 2005/2008 File – New Project – Business Intelligence Projects Report Server Project Wizard Set the Name:

Report Development / Authoring

Report Development / Authoring

Report Development / Authoring

Report Development / Authoring

Report Development / Authoring

Report Development / Authoring

Report Development / Authoring

Report Development / Authoring

Report Development / Authoring

Report Development / Authoring

Report Development / Authoring

Report Development / Authoring

Report Development / Authoring

Report Deployment

Report Deployment

On-Demand Retrieval (Pull)

On-Demand Retrieval (Pull)

Demo

DEMO

Discussion, questions & answers

Thank You