A Practical Guide to SharePoint 2013

A Practical Guide to SharePoint 2013
A Practical Guide to SharePoint 2013 - Book by Saifullah Shafiq

Thursday, September 15, 2011

Using SharePoint List data for Reporting Services (SSRS) parameter source (Via denglishbi)

Extracted from the original post

When creating reports with Reporting Services (SSRS) you might find yourself having to reference data that is stored in SharePoint lists. Another task that you might need to do is to leverage that same data that is stored in the list to filter the results that are displayed to the user in the report. Let’s take a look at a scenario for this type of a report request. In order to get setup for this scenario we are going to do a little prep work first though to get the data created for the example. We will do this right after we go over the scenario.

Scenario

A request comes in to create a report that provides a list of the stores and to provide a way for the users to filter the stores that they see on the report based on the location of the store; in this case they would like to filter the records by country. The request states that the information needed for the report is currently being stored and maintained in a SharePoint list.

Just a heads up, in this example we will be using SharePoint 2010 along with Reporting Services (SSRS) 2008 R2. SSRS 2008 R2 includes a new SharePoint List Connection Type. You will see screenshots of this down below in the Solution part.

Prep Work

Okay, first we are going to generate the list in SharePoint that is going to be the source for our report where the store information is entered and maintained so that we can do this example. We are going to do the following task:

For complete post, click here.