Deploy old SQL Reporting Services Reports to SharePoint Site

Overview

In my previous post, I discussed about how to setup SharePoint Integrated SQL Server Reporting Services (RS). Now that I have the Integrated RS ready, I can deploy the reports to the SharePoint site. But wait, how can I deploy a Pre-SP2 RS report to SharePoint site? Below shows the steps I used.

My RS reports consists of two files: a Report Definition file (.rdl) and a Data Source file (.rds). To deploy a Pre-SP2 RS report to a SharePoint site, I have to upload the Report Definition file, and create a new SP2 Data Source file (with extension changed to : .rsds).

Reference

1. Deploying Reports, Models, and Shared Data Sources to a SharePoint Site
2. How to: Create and Manage Shared Data Sources (SharePoint Integrated Mode)
3. How to: Add Report Server Content Types to a Library (SharePoint Integrated Mode)

Steps

Upload Report Definition file

1. Create a New Document Library (or use an existing one) in SharePoint site to store the Report Definition file and the Data Source file.
2. Upload the Report Definition file (.rdl) of your report to the Document Library created in Step 1.

Add "Report Data Source" Content Type to the Document Library

1. Before we can "New" a Data Source in SharePoint Document Library, we must first add the "Report Data Source" Content Type.
2. Navigate to the Document Library, select "Settings" -> "Document Library Settings"
3. Select "Advanced Settings"
4. Select "Yes" for "Allow management of content types", click "OK"
5. At "Document Library Settings", select "Add from existing site content types" under "Content Types" Category
6. Make sure that "All Groups" is selected for "Select site content types from:", then select "Report Data Source" Content Type and click "Add"
7. Click "OK"

Create a Data Source file in Document Library

1. Navigate to the Document Library, select "New" -> "Report Data Source"
2. Fill in the properties of the Data Source, I opened my old data source in visual studio and copy all the properties to the new one.
3. Click "OK"

Bind the Report Definition file to the new Data Source

1. Navigate to the Document Library, click to display the drop-down list of the Report Definition (.rdl) File
2. Select "Manage Data Sources" in the drop-down list
3. Click on the name of the Data Source to edit it.
4. Specify the URL of the newly created Data Source (.rsds) file in "Data Source Link" and click "OK"
5. Click "Close" to go back to Document Library, click on the Report Definition file to see the result. If a report is displayed successfully, then the deployment is done!