1 / 84

A Roadmap to Reporting Services in SQL Server 2005

A Roadmap to Reporting Services in SQL Server 2005. Ben Aminnia Pointer Corporation November 9, 2006. Agenda. Welcome Introduction Presentation Live Demos and Walkthroughs Concluding Remarks. Introduction. Introduction. Introduction. My Sources for Composing this Presentation

MikeCarlo
Download Presentation

A Roadmap to Reporting Services in SQL Server 2005

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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. What’s 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. What’s 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

More Related