Thursday, 11 July 2013

Importing an SSRS report and displaying it on a new environment

This is a 3 Series Post on SSRS 2012 for SharePoint 2010


Part 2 - (This Post) Importing an SSRS report and displaying it on a new environment

Overview:  This post looks at moving your SQL Server Report Services Report into a new farm (e.g. production).  I use the UI in this step-by-step guide.  I am using SQL 2012 for SSRS and SP 2010 as created in this post.

Assumptions:
  1. SP 2010 WFE's
  2. SQL 2012 SP1 is the database server
  3. Report (.rdl) is already created and uses a .rsds file to specify the connection string. 
Steps to migrate and deploy an existing SSRS report:
1. CA > Application Management > Manage Service Applications.
2. New > SQL Server Reporting Services Service Application > Fill in as shown below:
















3. Verify the Service Application is running.













4. Once Completed.  Open a Web Application that has the SSRS Service Application associated to it so we can test it out.  Login to a site collection and create a new library based on the "Reports Library" template.

5. Upload a report (.rdl) and the Connection (.rsds) file int he new "Report library". Then click the dataset/connection (.rsds) file, and test it is working.

6. Edit the binding of the rdl to it rsds as shown below:

7. Ensure you have the SP, scheme ect on the database server to perform the query logic.
8. Click on the report (rdl) file to see it working.
Tip: The install is fragile in that if the order, versions or settings are not right it doesn't work without giving error often.  Make sure SQL Servsions on all machines are the same!  I got caught by not having the same SQL version on 1 WFE as the backend SQL SSRS server.
This is a 3 Series Post on SSRS 2012 for SharePoint 2010

Part 2 - (This Post) Importing an SSRS report and displaying it on a new environment
 
Also I have an updated post on using SP2013 to us SSRS in SharePoint mode here.
 
Update: 24 Jan 2014 - PS to upload rdl's and data sources into a reporting library
 
$spWeb = Get-SPWeb "http://demo.dev/"
$spList = $spWeb.Lists["SSRS"]
$file = [io.file]::ReadAllBytes('C:\test.rdl')
$spList.RootFolder.Files.Add("test.rdl",$file)
# This code finds the SSRS reporting library called "SSRS" and takes a rdl file off the local drive and adds it to the library.

0 comments:

Post a comment