1 / 26

SQL Server Reporting Services

SQL Server Reporting Services. By Sam Nasr March 29, 2005. www.ClevelandDotNet.info. Agenda. Introduction Reporting Services 2000 Examples Reporting Services 2005 (Beta 2) Q&A Announcements Survey and raffle. Terminology. RDL: Report Definition Language

caelan
Download Presentation

SQL Server 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 ServerReporting Services By Sam Nasr March 29, 2005 www.ClevelandDotNet.info

  2. Agenda • Introduction • Reporting Services 2000 • Examples • Reporting Services 2005 (Beta 2) • Q&A • Announcements • Survey and raffle

  3. Terminology • RDL: Report Definition Language • Expression: custom code using keywords, ops, values, or functions (i.e. field, code). • Web Archive: self-contained, portable report with images (used for offline viewing).

  4. Features • Report Designer • Report Builder (Yukon) • Report Manager • Integration Services (Formerly DTS) • Management Tools • Tightly integrated with VS • Integrated with BI analysis services (Yukon).

  5. RS Architecture

  6. Subscription (trigger) Methods • When report runs • When data changes • Scheduled

  7. Report Formats • XML • CSV • PDF • TIFF • Excel • Web Archive (MHTML-embedded)

  8. Delivery Methods • File Server Share • E-mail • Null Delivery (stored in DB)

  9. Installation • Components of SQL Server • Reporting Services • Command line utilities • Virtual Directories • Reports (C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager) • ReportServer (C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer) • Databases • ReportServer – stores report formats, RDL, etc. • ReportServerTempDB – stores temporary data used in processing the reports.

  10. Security Tasks • Create linked reports • Manage all subscriptions • Manage data sources • Manage folders • Manage individual subscriptions • Manage report history • Manage reports • Manage resources • Set security for individual items • View data sources • View folders • View reports • View resources

  11. Security Roles (Default) • Browser: May view folders, reports and subscribe to reports. • Content Manager: May manage content in the Report Server. This includes folders, reports and resources. • My Reports: May publish reports and linked reports; manage folders, reports and resources in a users My Reports folder. • Publisher: May publish reports and linked reports to the Report Server.

  12. Yukon (Beta 2) Installation

  13. Yukon (Beta 2) Installation

  14. Yukon (Beta 2) Installation

  15. Yukon (Beta 2) Installation

  16. Yukon (Beta 2) Installation

  17. Yukon (Beta 2) Installation

  18. Yukon (Beta 2) Installation

  19. Yukon (Beta 2) Installation

  20. Yukon (Beta 2) Installation

  21. Yukon Release Dates • Currently Available: Beta 2 • May/June 2005: Beta 3 • End of 2005: Final Release

  22. Additional Info • SQL Server 2005 Webcasts: http://msdn.microsoft.com/sql/2005/2005Webcasts/default.aspx • SQL Server 2005 http://www.microsoft.com/sql/2005/ • SQL Server 2000 Reporting Services http://www.microsoft.com/sql/reporting/

  23. Recommended Books • Microsoft SQL Server 2000 Reporting Services Step by Step by Stacia Misner ($22.75) • Microsoft Reporting Services in Action by Teo Lachev ($30.95) • Introducing Microsoft SQL Server 2005 for Developers by Peter DeBetta ($16.95)

  24. New Hardware Say goodbye to password hassles.  Now you can log on to your computer and your favorite Web sites with the touch of your finger, without having to remember all those passwords—simply place your finger on the receiver whenever a password or username is required. » Learn more about the Fingerprint Reader.

  25. Announcements • New Web site:http://www.ClevelandDotNet.info • New Blog:http://ClevelandDotNet.blogspot.com • New Career Board:http://www.ClevelandDotNet.info/Careers.html

  26. Upcoming Events • April 21: SQL Server SIG meeting Internationalization with SQL Server by Michael Kaplan (Microsoft) • April 25: C#/VB.Net SIG meeting Whidbey Globalization by Michael Kaplan (Microsoft) • May 12: MSDN http://msevents.microsoft.com

More Related