1 / 10

SQL Server 2005 Reporting Services

SQL Server 2005 Reporting Services . SommarKollo Microsoft. Agenda. Introducing Reporting Services Reporting Services Component Overview Creating Reports Deploying Reports Browsing Reports Administering Reports Conclusion. Introducing Reporting Services.

khan
Download Presentation

SQL Server 2005 Reporting Services

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. SQL Server 2005 Reporting Services SommarKollo Microsoft

  2. Agenda • Introducing Reporting Services • Reporting Services Component Overview • Creating Reports • Deploying Reports • Browsing Reports • Administering Reports • Conclusion

  3. Introducing Reporting Services • Business Intelligence Component • Rich set of tools • Graphic Environment • A lot for “free” • A lot “Auto Magic” • Versatile Report Design • Server-based reporting platform • Report Server • Windows Service • Web Service • Database Storage

  4. Reporting Services Component Overview • Managed Environment • Report Server • Windows Service • Initialization • Scheduling • delivery • Web Service • Programmatic Access • Data Sources • Relational • Multi Dimensional • Procession Extensions • Rendering Extensions • Report Manager

  5. Creating Reports • Report Designer • Developer Driven • Visual Studio Shell • Infrastructure & layout • Report Wizard, use without shame • Manual development, could be time-consuming • Report Builder • End User Driven • Developer Initiated • Ad Hoc for users • RDL • XML based language

  6. Deploying Reports • Standard • Single Instance of Report Server • Local or remote database • Scale Out • High availability • Performance • Single report database Load Balanced High Availability

  7. Browsing Reports • Rendring Extensions • XML • CSV • Image (TIFF) • PDF • Excel • HTML • OWC • NULL (Cache) • Web • URL Access [Parameters] • Report Manager • Rendering Extensions • Mail | File Share | Custom • Printing • Subscriptions “OR” Intermediate Format like Cache, Snapshots or Report History On Demand Data Report Definition Queries Expressions CodeReferences Rendered Reportby aRendering Extension Schema or Push Layout

  8. Tools for Administering Reports • SQL Server Configuration Manager • SQL Server Surface Area Configuration • SQL Server Management Studio • Report Manager • Reporting Services Configuration Tool • Reporting Services Command Line Utilities

  9. What to Administer • Relational databases • Metadata & object definitions • Security • Role-based & Windows authentication or Custom • Report Execution • Automating Reports • Encrypted values • Web Service • Windows Service • Logs • Performance

  10. Conclusion • Several data sources • Several report formats • Flexible authoring • Rendering extensions • Server based • Centrally managed • Managed environment

More Related