300 likes | 469 Vues
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??????.
E N D
SQL Server Reporting ServicesSharePoint Integrated Mostafa Absy SharePoint Team Leader wmostafaw
Why Reporting Services?????? • Who is the user which has the most number of tasks?
Why Reporting Services?????? • Who is the user which has the most number of completed tasks?
Why Reporting Services?????? • Presentation Layer • Visualize Data • Make a Decision
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
SSRS Modes • Native
SSRS Modes • SharePoint Integrated
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
Topologies • Standalone Server Deployments
Topologies • Two-Computer Deployment
Topologies • Two-Computer Deployment
Topologies • Three-Computer Deployment
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
Installation • Install both Reporting Services and the Database Engine
Installation • Install Reporting Services in Integrated Mode
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
Development • Report Designer VS 2008, 2011
Development • Report Builder 3.0
Deployment • VS
Deployment • Report Builder 3.0
Deployment • Upload Manually to document library