SQL Reporting Services

1. SQL Reporting Services From a Developers Perspective Adam Calderon Principal Engineer Interknowlogy LLC adamc@interknowlogy.com http://blogs.interknowlogy.com/adamcalderon/

2. Agenda • Introducing Reporting Services • 2005 Enhancements • Reporting Services Component Overview • Anatomy of a Report • Designing and Creating Reports • Integrating Reports with Applications • Advance Reports

3. What is Reporting Services ? • Sever based reporting platform • Complete set of tools to create, manage and view reports • Variety of output formats HTML, PDF, TIFF, Excel, CSV and custom • Reports can be based on relational and multidimensional data • Exposed API

4. Reporting Services Scenarios • Business Reporting • Ad hoc Reporting • Integrating Reporting Services in Custom Applications • Data Reporting • Intranet Reporting • Building Custom Report Design and Management Tools • Extending Reporting Services Functionality

5. Report Functionality Enhancements • Interactive Sorting in Reports • Printing Reports • Creating Ad Hoc Reports • Mutivalued Parameters • SharePoint Web Parts

6. Design-Time Enhancements • New Model Designer • Report Designer Enhancements • Expression Editor Enhancements • Expression-based Data Sources • New Analysis Services Query Designer • Integration Services Enhancements • Report Definition Enhancements

7. Reporting Services Programmability Enhancements • New SOAP Endpoints for the Report Server Web Service • Management Endpoint • Execution Endpoint • New Report Viewer Controls in Visual Studio 2005

8. Reporting Services Components • Report Server • Report Processor • Scheduling and Delivery Processor • Report Server Database • Extensions • Report Manager • Report Builder • Report Designer • Model Designer • Configuration Tool

9. Component Architecture Browser Report Builder (new) Report Designer Model Designer (new) Reporting Services Configuration Tool (new) Third-Party Tools Report Manager Programmatic Interfaces Report Server Report Processor Schedule and Delivery Processor Data Retrieval Rendering Delivery Security Report Server Database

10. Quick Tour of Reporting Services

11. Components of a Report • Data Sources • DataSets • Fields • Data Regions • Report Items • Report Definition Language (RDL)

12. Report DataSources Data Processing Extensions retrieve the data that is used in reports. The following are build-in extensions. • SQL Server Data Processing Extension • Analysis Services Data Processing Extension • Oracle Data Processing Extension • OLE DB Data Processing Extension • ODBC Data Processing Extension • XML Data Processing Extension (New to 2005)

13. Report Data Regions • Table • Matrix • List • Chart • Nested Data Regions

14. Report Items • Text Box • Image • Line • Rectangle • Subreport • Item Properties

15. Report Definition Language (RDL) • Set of instructions that describe layout and query information for a report • Composed of XML • Extensible and open schema that supports additional namespace and custom elements

16. Creating Reports

17. Report Control (Remote Mode) Custom Application Report Control Programmatic Interfaces Report Server Report Processor Schedule and Delivery Processor Data Retrieval Rendering Delivery Security Report Server Database

18. Report Control (Local Mode) Custom Application Report Control Report Processor DataSet SQL Database Resource File (rdl)

19. Integrating Reports with Applications

20. Advanced Reports