Document

Download Report

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