SharePoint and SQL Server Reporting Services

Posted on 12/23/2007 @ 1:33 AM in #SharePoint by | Feedback | 12605 views

If there was one topic that was under-explored, under-documented, and uber-powerful, that would be SharePoint 2007 working with SQL Server reporting services.

In the next few blogposts, I will be talking about the various aspects of SharePoint 2007, and SQL server reporting services.

So to start with, here is a TOC -

  1. SharePoint and Reporting Services - Introduction
  2. SharePoint and Reporting Services - Installation and Setup.
  3. SharePoint and Reporting Services - Setup your database.
  4. SharePoint and Reporting Services - Authoring a simple report.
  5. SharePoint and Reporting Services - Enabling end users - the report model.

Sound off but keep it civil:

Older comments..

On 1/12/2008 12:56:58 AM Chris Nieboer said ..
Do you require Sharepoint Portal Server 2007? Or can you use the latest Free version of WSS. How does this work with Shareppint Portal Server 2003?

On 7/10/2008 2:25:14 AM Tuhin said ..
I am very interested to work Microsoft Share point server and Sql server 2005 reporting services

On 8/18/2008 7:39:17 AM Richard said ..
Interested in mechanics of MOSS with ssrs

On 8/18/2009 12:00:43 AM Maurice said ..
Hope it will be informative :-)

On 10/5/2009 5:26:59 PM Khushi said ..
Hi Sahil,

I am about to start working on the sharepoint project. The project revolves around the document workflow. The company is wiping out the old solution which was developed by the third party. That was built upon the InfoPath Form. Since Infopath forms limitations is restricting to carry on the development ahead.

The new consultant we hire is suggesting my team lead/manager to put the data outside of the SharePoint Database. They are suggesting to build the application as ASP.NET Webapplication. They are convincing that it is hard to produce MIS Reports if we store data into Sharepoint Lists. Also, It is difficult to integrate the application/system with other system.

They just want to use sharepoint only for Profiles and Groups and their Security as the profiles would pulled from Active Directory.

I feel wierd about this because its like forcing Sharepoint in the organisation. When the application is build as ASP.NET Web application why are we using SharePoint. We are not leaveraging the SharePoint's capability.

So, As you are a SharePoint Experts I request you to please guide me, is this the way to rollout the sharepoint applications in an organization. Is it really hard to produce a reports and to integrate with other systems in SHAREPOINT/MOSS. Is it sensible to store data outside the sharepoint when you want to use Sharepoint.

Thanks & Regards,


On 3/4/2010 10:24:36 AM ahmed said ..

On 6/28/2010 12:36:31 PM Nova said ..
IT's very good article.