1 / 12

Reporting Services

Reporting Services. Introducing Reporting Services. What is SSRS? Component of SQL Server Included free since SQL 2000 Design tools (BIDS, Report Builder) also free Users need SQL CAL to access data Runs as web service SOAP / XML Separate from IIS. Who Uses Reporting Services?.

tao
Download Presentation

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. Reporting Services

  2. Introducing Reporting Services • What is SSRS? • Component of SQL Server • Included free since SQL 2000 • Design tools (BIDS, Report Builder) also free • Users need SQL CAL to access data • Runs as web service • SOAP / XML • Separate from IIS

  3. Who Uses Reporting Services? • Executives and Managers • Typically high-level summary and aggregate reports • Information Workers • Low-to-mid level data consumers • Anyone requiring self-service BI • Systems Administrators • Good at presenting system metrics

  4. How Does SSRS Deliver BI? • SSRS Home • Intranet application is the primary method • Report Container .NET part • WinForms or ASPX • All methods available via .NET • Parameterised URLs • Report parameters can be passed via ASPX parameters • Report Builder • Self-serve BI via published data models • Subscriptions • Scheduled reports sent via email over SMTP

  5. Security in SSRS • Windows Authentication • Folder-based • Users or Groups must be granted access to report folders • Role-based • Users may browse, publish or edit • Row-level data security is possible • @UserID can be passed to the SQL query • The user can then be allowed to view specific Heritage or Market

  6. SQL or MDX-based query Any ODBC Data Source Most VBA functions work in designer Not documented or supported .NET can be embedded Report structure saved as RDL (Report Definition Language) Proprietary XML Report Creation

  7. Data can be grouped and nested Able to drill-down Data can be “pivoted” using the Matrix Advanced formatting and formulas available Report Creation

  8. Users can pick and choose report items they want Report publishers create and deploy stand-alone components Tables Charts Maps (UK can be downloaded) Gauges (Dundas) Consumers use Report Builder to create dashboards Report Parts

  9. Two methods From within BIDS (Business Intelligence Designer Studio) Use in Development environments Upload RDL files directly to SSRS folder using browser Used in Production or off-premise environments Report Deployment

  10. Dashboard Reports

  11. Create a web service reference as a proxy class • Uses the SSRS 2005 address in all versions (not deprecated) • Load Report • Render • Write to file Report Execution Service

  12. Reports may be executed directly via URL • Parameters set as standard ASPX page parameters • Use standard http encoding • Export format (XLS, PDF etc) are also specified Access via URLs

More Related