Transcript Document

Welcome to the First Annual
SharePoint Saturday
Sacramento!!
SQL Reporting Services and SharePoint
‘The Right Way’
Maarten Sundman
Slalom Consulting
[email protected]
Easy report building
 Simple report display
 Browsing available reports

Benefits of SSRS Integration

Requires SharePoint and SQL on same
box
◦ Additional maintenance and overhead
◦ Significant cost
◦ No segregation of services
Removes SSRS Web Admin
 All or nothing approach

Key Issues with SSRS Integration





Simple browsing
Integrated display
Simple report building
No custom code!
SSRS Web Admin
◦ Permissions
◦ Scheduling of building data sets
Best of Both Worlds
Use the Click Once link for Report Builder
 Use the Report View from the SSRS web
application for displaying reports
 Display Available Reports using the
minimal UI inside a page viewer web part

How to Build Our Ideal
How it all comes together
 Which SSRS services do we use

DEMO!



My Blog: http://www.withinsharepoint.com
My Email: [email protected]
My CodePlex: http://sp2010ext.codeplex.com
More Questions
Maarten Sundman
Slalom Consulting
[email protected]
Sponsored By…..
Join us at 6:00 pm at BJs
Brewhouse for a free drink,
kindly provided by Rackspace! A
great opportunity to network with
other SharePoint Professionals!
Don’t forget to fill out your bingo cards and surveys to be
eligible for GREAT end of day raffles!