A Roadmap to Reporting Services in SQL Server 2005

1
A Roadmap to Reporting Services inSQL Server
2005

• Ben Aminnia
• Pointer Corporation
• November 9, 2006

2
Agenda

• Welcome
• Introduction
• Presentation
• Live Demos and Walkthroughs
• Concluding Remarks

3
Introduction
4
Introduction
5
Introduction

• My Sources for Composing this Presentation
• A Full-day Class SSRS / Dundas Chart / Chart FX
• SSWUG Webcast Introduction to SSRS
• AppDev Training DVD SSRS
• Misc. Online Sources Personal Notes

6
Introduction
7
Introduction
8
Introduction
9
A Video Clip

• BI_Creating-MaintainingReports500k.wvx

10
Introduction

• SQL Server Reporting Services
• SSRS
• ????
• SRSS

11
Whats in a Roadmap?

• A Roadmap is NOT ...
• A list of new features
• SELECT TOP Clause with a Parameter
• CROSS APPLY/OUTER APPLY Table ? UDF
• Native XML Support
• A comparison to competing products
• SSRS vs. Crystal Reports
• A decision tool

12
Whats in a Roadmap?

• A Roadmap is ...
• Used after the decision has been made and the
  destination has been determined
• A step-by-step guideline for successfully
  reaching the destination

13
SSRS Roadmap

• Understanding ...
• The Components
• The Objectives
• The Tools
• Setup
• Development / Authoring
• Deployment
• Distribution / Delivery
• Event-based (push)
• On-demand (pull)
• Management / Adhoc Development
• Report Manager (administrator)
• Browser-based
• Desktop-based
• Report Builder (end-user)

14
SSRS Components

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

15
SSRS Components

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

16
SSRS Components

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

17
SSRS Components

• Output Formats ...
• HTML
• Excel
• CSV
• PDF
• XML
• Custom

18
SSRS Components

• Delivery Targets ...
• E-mail
• File Share
• Custom

19
SSRS Components

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

20
SSRS Setups

• Developer Machine
• Report Server
• User Machine

21
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

22
Report Development / Authoring

• Create RS Project
• Open Visual Studio 2005
• File New Project Business Intelligence
  Projects
• Report Server Project Wizard
• Set the Name

23
Report Development / Authoring
24
Report Development / Authoring
25
Report Development / Authoring
26
Report Development / Authoring
27
Report Development / Authoring
28
Report Development / Authoring
29
Report Development / Authoring
30
Report Development / Authoring
31
Report Development / Authoring
32
Report Development / Authoring
33
Report Development / Authoring
34
Report Development / Authoring
35
Report Development / Authoring
36
Report Deployment
37
Report Deployment
38
SSRS Roadmap

• Understanding ...
• The Components
• The Objectives
• The Tools
• Setup
• Development / Authoring
• Deployment
• Distribution / Delivery
• Event-based (push)
• On-demand (pull)
• Management / Adhoc Development
• Report Manager (administrator)
• Browser-based
• Desktop-based
• Report Builder (end-user)

39
SSRS Roadmap

• Understanding ...
• The Components
• The Objectives
• The Tools
• Setup
• Development / Authoring
• Deployment
• Distribution / Delivery
• Event-based (push)
• On-demand (pull)
• Management / Adhoc Development
• Report Manager (administrator)
• Browser-based
• Desktop
• Report Builder (end-user)

40
SSRS Roadmap

• Setup
• Developer Machine
• Visual Studio 2005
• or
• SQL Server 2005 BI Development Studio
• Report Server
• SQL Server 2005 - Components

41
Reporting Services Setup
42
Reporting Services Setup
43
Reporting Services Setup
44
Reporting Services Setup
45
Reporting Services Setup
46
Reporting Services Setup
47
Reporting Services Setup
48
Reporting Services Setup
49
Reporting Services Setup
50
Reporting Services Setup
51
Reporting Services Setup
52
Reporting Services Setup
53
Reporting Services Setup
54
Reporting Services Setup
55
Reporting Services Setup
56
Reporting Services Setup
57
Reporting Services Setup
58
Reporting Services Setup
59
Reporting Services Setup
60
Reporting Services Setup
61
Reporting Services Setup
Remember! The name is ReportServer. Hence, we
will be using http//localhost/reportserver
62
Reporting Services Setup
63
Reporting Services Setup
64
Reporting Services Setup
Remember! The name is Reports. Hence, we will
be using http//localhost/reports
65
Reporting Services Setup
66
Reporting Services Setup
67
Reporting Services Setup
68
Reporting Services Setup
69
Reporting Services Setup
70
Reporting Services Setup
71
Reporting Services Setup
72
Reporting Services Setup
73
Reporting Services Setup
74
Reporting Services Setup

• http//localhost/reportserver

75
Reporting Services Setup

• http//localhost/reports

76
Report Deployment
77
Report Deployment
78
On-Demand Retrieval (Pull)
79
On-Demand Retrieval (Pull)
80
ReportViewer

• A Visual Studio 2005 Control
• Embedded SSRS Reports within Applications
• Usable both in Windows and Web Forms
• Remote Processing Mode
• Using SSRS Report Server
• Local Processing Mode
• Using Application-provided Datasets and
  Parameters
• Ref Brian Larsons two-part article in SQL
  Server magazine, Oct. and Nov. 2006

81
Additional SSRS Topics(Maybe in a Part 2
Presentation?)

• Other Output Formats (besides HTML)
• Event-based (Push) Delivery
• Preventing Unauthorized On-demand (Pull) Delivery
• Working with Parameters
• Query Parameters (for the Data Source Server)
• Report Parameters (for the Report Server)
• System Administration (Report Manager)
• End-user Reporting Tool (Report Builder)

82
Additional SSRS Resources

• Installing
• http//msdn2.microsoft.com/en-us/library/ms143736.
  aspx
• Debugging / Publishing
• http//msdn2.microsoft.com/en-us/library/ms159087.
  aspx
• Troubleshooting
• http//msdn2.microsoft.com/en-us/library/ms159135.
  aspx
• Q A
• http//www.sswug.org/see/17420 (26 Pages)
• http//www.sswug.org/see/17423 (18 Pages)
• http//www.sswug.org/see/30787 (3 Pages)

83

• Thanks to Microsoft, AppDev, and SSWUG!
• Special Thanks to our Friends at LADOTNET!

84
My Contact Information

• Ben Aminnia
• www.pointercorp.com
• www.TAKEaTEST.net
• ben_at_pointercorp.com
• president_at_sql.la
• Happy New Year!