SharePoint & SSRS

As companies rely more and more on Sharepoint 2007 as a central collaboration and business intelligence (BI) platform, there comes a time when the big wigs might ask you – the local SharePoint Ninja – to develop some pretty charts and dashboards for their viewing and decision making pleasure.

“No problem”, you respond.  But you haven’t the slightest clue how to build a SQL Server report, and you sure don’t know how to make it centrally available to the power users within the company.

This article is a follow up to Part 1 – It’s Time to Work Your SharePoint Ninja Magic, an Introduction post of the series titled Surfacing Company Data through Sharepoint 2007 and SQL Reporting 2008 Services. In the first article I described a common scenario in which you, the SharePoint Ninja, were assigned a project to create some nice looking and useful business intelligence tables and graphs in your SharePoint environment. This article begins with a description of the synchronization between the SharePoint 2007 databases and the Reporting Services databases. We will then walk you through the Report Server configuration. Before we continue, please make sure have setup, configured, and downloaded the necessary prerequisites prior to continuing. Assuming you have those in place and Reporting Services installed, let’s go over the different database roles in this reporting solution.

This is the third post in the series Surfacing Company Data through Sharepoint 2007 and SQL Server 2008 Reporting Services. In the previous post titled Configuring the Report Server, we walked through an overview, the creation, and the configuration of the Report Server databases from the Report Server. In this article we’ll move on to the SharePoint side of things. We’ll cover an overview, installation, and configuration of the Reporting Services Add-in for SharePoint Technologies.

This is the fourth post in the series Surfacing Company Data through Sharepoint 2007 and SQL Server 2008 Reporting Services. In the previous post titled Part 3 – Configuring SSRS on the SharePoint Web Servers, we walked through the installation and configuration of the Reporting Services Add-in for SharePoint technologies. In this article we will get into the fun parts of the solution – building SQL Server reports and viewing them in SharePoint 2007.