1 / 30

SQL Server Reporting Services SharePoint Integrated

SQL Server Reporting Services SharePoint Integrated. Mostafa Absy SharePoint Team Leader. wmostafaw. Why Reporting Services??????. Why Reporting Services??????. Why Reporting Services??????. Who is the user which has the most number of tasks?. Why Reporting Services??????.

nadine-snyder
Download Presentation

SQL Server Reporting Services SharePoint Integrated

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 Reporting ServicesSharePoint Integrated Mostafa Absy SharePoint Team Leader wmostafaw

  2. Why Reporting Services??????

  3. Why Reporting Services??????

  4. Why Reporting Services?????? • Who is the user which has the most number of tasks?

  5. Why Reporting Services?????? • Who is the user which has the most number of completed tasks?

  6. Complex Report

  7. Why Reporting Services?????? • Presentation Layer • Visualize Data • Make a Decision

  8. Architecture Overview Windows Server Corp Data /Reports HTTP.SYS SQL Users & Admins Running IE /ReportServer Reporting Services Oracle Htmlpdfxls RDL RDL Other Developer Tools SQL Server ReportServer ReportServerTempDB Custom Code

  9. SSRS Modes

  10. SSRS Modes • Native

  11. SSRS Modes • SharePoint Integrated

  12. Why SharePoint 2010 Integration? • Keep in SharePoint • SharePoint features: • Permissions • Versioning • Alerts • Multiple SharePoint Zones • Backup / Restore • Claims Based Authentication • ULS • Recycle Bin • Portal • Manage • Publish & Upload • View

  13. Topologies

  14. Topologies • Standalone Server Deployments

  15. Topologies • Two-Computer Deployment

  16. Topologies • Two-Computer Deployment

  17. Topologies • Three-Computer Deployment

  18. Installation • Reporting Services Add-in for SharePoint Products (rsSharepoint.msi) • SharePoint • Report Server proxy • Report Viewer Web part • Application pages • On each WFE • Reporting Server • SOAP endpoint • Delivery extensions

  19. Installation • Install both Reporting Services and the Database Engine

  20. Installation • Install Reporting Services in Integrated Mode

  21. Installation • Run the SharePoint 2010 Products Preparation tool • Install a SharePoint 2010 product • Run SharePoint Configuration Wizard • Configure Reporting services from CA • Join Reporting Services server to the farm

  22. Development

  23. Development • Report Designer VS 2008, 2011

  24. Development • Report Builder 3.0

  25. Deployment

  26. Deployment • VS

  27. Deployment • Report Builder 3.0

  28. Deployment • Upload Manually to document library

  29. Demo

More Related