SQL Server Features and Components

SQW05 Integrating Reporting Services with SharePoint

11/20/2013

11:00am - 12:15pm

Level: Intermediate

Kevin Goff

Kevin Goff

Microsoft SQL Server MVP

Practice Manager

SetFocus, LLC

Have you ever seen a SharePoint site that integrates reports from SSRS, and wonder how all the pieces fit? If so, this session is for you. I'll cover the necessary integration/configuration steps for integrating SSRS 2008R2/SSRS 2012 with SharePoint 2010/2013, as well as deploying reports to a SharePoint location. Along with that, I'll show how you can define SSRS as a service application inside of SharePoint. I'll also show how to integrate SSRS reports into SharePoint/PerformancePoint Services dashboard pages, as well as how to schedule reports for delivery to SharePoint document libraries. You'll see the improvements from Microsoft that make reporting against SharePoint lists much easier than before. Finally, time permitting, I'll show the new Data Alerts feature in SharePoint.

You will learn:

  • The requirements (and differences) in deploying reports using SQL 2008R2 or 2012 with SharePoint 2010 and 2013, as they are different for each combination (I'll have a feature matrix)
  • How to schedule reports for delivery to SharePoint document lib