Introduction To Reporting Services SSRS Presented by Wes

Introduction To Reporting Services (SSRS) Presented by: Wes Springob Business Intelligence Developer, Agile Bay, Inc.

Customers & Partners Wes Springob Current Positions: Business Intelligence Developer at Agile Bay Member of SQL Pass Tampa Blog: [http: //SQLWes. com] Twitter: [@SQLWes] Linked-in: http: //www. linkedin. com/in/SQLWes Email: nsert Picture WSpringob@agilebay. com

www. agilebay. com

Session Agenda �Brief overview of Reporting Services. �Demonstration, Building your first report. �Q&A

Terms and Acronyms �(SSRS) SQL Server Reporting Services: Microsoft’s Reporting solution. �(BI) Business Intelligence: Reporting and Analysis of business data. � (. rdl) RDL: Report Definition Language (XML), or a Reporting Services report definition file.

Overview of Reporting Services More than just reports

SQL Server Reporting SERVICES � Provides a presentation method for sharing reporting and analysis throughout an organization and to the public. � Provides administration tools to manage versions, branding, security and distribution of reports. � Provides tools for developers to create reports.

SQL Server Reporting Services � Supports virtually any database or data source. � OLE (Deprecated) � ODBC � SQL Server � Parallel Data Warehouse (PDW) � SQL Azure (Cloud Database) � SQL Server Analysis Services � Oracle � XML � Teradata � Can be presented in a variety of methods � Through Report Manager � Embedded in a web page using the Report Viewer. Net Control � Through Share. Point � In a Windows application � As HTML in an Email

SQL Server Reporting Services � Reports can be easily transformed into popular formats. � Word � Excel � CSV � PDF � HTML � Tif � XML � RSS Data Feed

Demo: Building your first report

Demo: �Introduction to Report Manager �Shared vs. embedded Data Sources �Shared vs. embedded Data Sets �Report Builder �Deploying your report �Securing your report �Distributing your report �Enhancements

Summary

Summary �SSRS is more than just reports. �Report Manager is the hub of SSRS administration. �Report Builder provides an easy to use development environment for creating RDLs.

Additional Resources

Additional Resources � Technet (2008 R 2) http: //technet. microsoft. com/en-us/library/ms 159106(v=sql. 105). aspx � Brian Swan’s MSDN Blog http: //blogs. msdn. com/b/brian_swan/archive/2010/04/29/getting-started-with-sqlserver-reporting-services-ssrs. aspx � Report Builder 3. 0 (2008 R 2) http: //technet. microsoft. com/en-us/library/dd 207008(v=sql. 105). aspx

Thank you for attending! Q&A Blog: http: //SQLWes Twitter: @SQLWes Linked-in: http: //www. linkedin. com/in/SQLWes Email: WSpringob@agilebay. com