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