Transcript Slide 1
27. to 28. March 2007 | Geneva, Switzerland
Fabrice Romelard
ilem SA
Level 200
27. to 28. March 2007 | Geneva, Switzerland
Presentation
MVP since 2003
ASP.NET 2003-2006
SQL Server Since 2006
French communities member
ASP-PHP
Codes Sources
GUSS
.NET developer, SQL Server DBA and
Sys. Admin
Coworkers ilem SA at Geneva (Suisse)
Survey
SQL Server 2005-2000 ?
SQL Server Reporting Services ?
SharePoint V2-V3 ?
Key Takeaways
Deep integration of Reporting Services 2005 with
SharePoint Technologies
Enables publishing, viewing, management, and
delivery of SSRS reports in SharePoint libraries
Report web part for hosting rich reports in BI
dashboards including filter Web Part integration
Leverage SharePoint collaboration and workflow
capabilities with rich reporting
SharePoint Integration Today
SSRS Integration with SharePoint ‘v2’
Report Explorer allows users to browse and subscribe to reports
Report Viewer allows for users to view and navigate reports
•
Limitations
•
•
Separate content stores
Different security models
•
Different management UI
•
Not deployable outside of firewall
•
No filter web parts
SSRS & SharePoint Integration
• Seamless integration with SharePoint
Document Library in Office SharePoint
Server 2007
• Report server namespace and security is
hosted in WSS content database
• SharePoint database stores Report Server
reports, data sources, models, resources etc.
• Report Server database used for additional
metadata (schedules, caching, subscriptions)
• Enables collaboration, workflow, versioning
SSRS & SharePoint Integration
•
Centralized user interface for Report
Management through Office SharePoint Server
2007
•
•
•
Upload, manage, render and deliver Reports all
through Office SharePoint Server 2007 UI
Administration using Office SharePoint Server 2007
Rich reporting experience to “light up” Office
SharePoint Server 2007
•
Filter web parts enhancing dashboards in Office
SharePoint Server 2007
DEMO N°1
DOCUMENT LIBRARY INTEGRATION
Architecture
SQL Server 2005 SP2
SSRS Add-In Install
SSRS 2005
WSS 2007
SP2 Report Server
Reporting Services Add-in
Report Viewer Web Part
Report Management UI
Security Extension
Catalog Management
WSS Object Model
WSS Object Model
Report Server DB
SharePoint Content DB
Database Integration
WSS Content Database stores the master
copy of SSRS items
Get Master Copy from
WSS DB
NO
Run Report
•
•
Exists?
Yes
ON
Master?
Yes
Schedules, caching, and subscriptions are stored in SSRS
database only
No automated migration path from existing SSRS
installations
Report Tools
Report Designer, Report Builder, Model Designer
are updated to work in SharePoint Integration
mode.
Report Manager, Management Studio, My
Reports, Linked Reports, and Job Management
SSRS features not supported in SharePoint
Integration mode
Reports, data sources, and report models are
managed via the SharePoint user interface.
DEMO N°2
REPORT BUILDER INTEGRATION
ReportViewer Web Part
Used in full page view or on Web Part Pages
Wraps the ReportViewer ASP.NET Control
Handles report rendering calls to report server
Supports Filter consumer and Row consumer
interfaces for specifying report parameter values
via filter web parts
Can slice Excel Workbooks and reports
together
REPORT VIEWER
Programmability Details
New report server SOAP endpoint for use in
SharePoint Integrated mode only.
Database integration in SharePoint Integrated
mode results in SOAP APIs call into WSS DB’s
using WSS OM
Updated WMI provider for use in Native or
SharePoint Integrated mode
Reporting Services security role definitions are
replaced with SharePoint roles.
Security Mapping
SSRS security operations map to SharePoint
Web or List rights.
CreateReport( )
•
Add Items
New Site permissions replace System permissions.
CreateSchedule( )
•
CreateReport
operation
CreateSchedules operation
Model Item security is still managed by SSRS.
Manage Web Site
Security Modes
Windows Integrated & Trusted Account
Windows User
Non-Windows
User
WSS Web Application
with Windows
Authentication
WSS Web Application
(non-Kerberos or
Custom Authentication)
Windows User
Trusted Account
&
SharePoint User
token
SSRS SP2
Summary
Seamless integration with SharePoint
Document Library in Office SharePoint Server
2007
Centralized user interface for Report
Management through Office SharePoint
Server 2007
Rich reporting experience to “light up” Office
SharePoint Server 2007
Resources
Reporting Services on the web :
http://www.microsoft.com/SQL/Reporting
Blogs
http://blogs.developpeur.org/fabrice69/
http://blogs.developpeur.org/christian/
Technet
http://www.microsoft.com/technet/prodtechnol/sql/
2005/technologies/rptsvcs.mspx
NewsGroups SQL Server et SharePoint
Forums SQL Server et SharePoint
27. to 28. March 2007 | Geneva, Switzerland