Reporting Services

1
Reporting Services

• Presented by David Klein Adam Cogan

2
Admin Stuff

• Attendance
• You initial sheet
• Hands On Lab
• You get me to initial sheet
• Certificate
• At end of 10 sessions
• If I say if you have completed successfully ?

3
About

• David Klein is a Senior Software Architect at
  SSW, specialising in .NET SQL Server BI
  solutions
• Current Clients Sally Knox Medical Pisces
• Adam Cogan is Chief Architect at SSW and one of 2
  Microsoft Regional Directors in Australia,
  specialising in Office, SQL and .NET solutions

4
Course Overview

• The 5 Sessions (Part B)
• SSIS and Creating a Data Warehouse
• Creating a Cube and Cube Issues
• Reporting Services
• Other Cube Browsers
• RS Report Builder
• Excel 2007
• Proclarity
• Thin Slicer
• zzCrystal
• Data Mining
• http//www.ssw.com.au/ssw/events/2006SQL

5
Session 3 Tonights Agenda

• What is SQL Reporting Services?
• Steps in Creating a Report
• Demo Creating a Report
• Hands on Lab

6
SQL Server BI Platform
Reporting Services
Management Tools
Development Tools
Analysis Services OLAP Data Mining
Integration Services ETL
SQL Server Relational Engine
7
What is SQL Server Reporting Services?

• Reporting platform for both traditional and
  interactive reports
• Scalable and manageable server infrastructure
• Integrated with SharePoint, Office applications,
  browser and other familiar tools
• Single platform and tools for all types of
  structured data (relational, hierarchical,
  multidimensional)

8
Reporting Lifecycle
Reporting Services is an open and extensible
platform supporting the authoring, management and
delivery of rich, interactive reports to the
entire enterprise.
9
Report Authoring

• Reports are defined in Report Definition Language
  (RDL), a documented XML schema
• Use Microsoft or 3rd party tools that support RDL
  
• Create single reports from multiple data
  sources(SQL, OLE DB, ODBC, Oracle, and .NET data
  providers)

More info on the RDL spec www.microsoft.com/sql/r
eporting
10
Report Authoring - Controls

• Data regions
• Table
• List (like Access)
• Matrix
• Chart
• Subreports
• Images
• Scope (lab)
• Custom Controls

11
Report Management

• Report definitions, folders, and resources are
  published and managed in a reporting web service
• Managed reports can be executed either on-demand
  or via schedule and can be cached for
  consistency and performance
• Scalable Extensible server architecture

12
Report Delivery

• Traditional (paper) and interactive (web) reports
• On-demand (pull) or event-based (push)
  delivery
• Choose from multiple formats (HTML, Excel, PDF,
  XML)
• Deliver reports to many devices (e-mail, file
  share, etc.)
• Ad-hoc Reporting

13
SSRS and SSAS Working Together
Standard reports Ad hoc reports
Detail reports
SSAS
SSRS

• Intuitive reporting
• Interactive analysis
• High performance
• Powerful calculations

• Detail reporting
• Standard reporting
• Ad hoc reporting
• Flexible delivery

14
SSRS Extensibility

• Reference .NET assemblies
• Data Processing Extensions
• Rendering Extensions
• Delivery Extensions
• Integrate into your applications
• Using the Web Service
• Hitachis Crystal -gt RDL tool

15
SSAS and Reporting Services
Data Layer
SSAS
Presentation Layer
UnifiedDimensionalModel
ETL
DB1
Interactive reporting
UDM
DB2
DW
Standard reporting
DB3
multiple data sources supported
Ad hoc reporting

• Dimensional schema intuitive reporting
• SSAS for better performance and business metrics
• UDM serves many reporting needs

16
(No Transcript)
17
Report Builder Drill-through Reports

• Start in Report Builder
• Get the data you want
• In report properties choose Allow users to drill
  to this report option
• Optionally customize in Report Designer

18
Analysis Services Actions

• UDM extensibility feature
• Browser-specific implementation
• Action types
• Regular actions multi-purposed commands
• Drillthrough actions get details behind cell
• Reporting actions launch SSRS report

19
Summary

• What is Reporting Services?
• Steps in Creating a Report
• Demo Creating a Report
• Hands on Lab

20
2 things
DavidKlein_at_ssw.com.au AdamCogan_at_ssw.com.au
21
Thank You!
BI is Cool