Download
sql server 2005 reporting services n.
Skip this Video
Loading SlideShow in 5 Seconds..
SQL Server 2005 Reporting Services PowerPoint Presentation
Download Presentation
SQL Server 2005 Reporting Services

SQL Server 2005 Reporting Services

330 Vues Download Presentation
Télécharger la présentation

SQL Server 2005 Reporting Services

- - - - - - - - - - - - - - - - - - - - - - - - - - - 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