SSRS Explorer

Installing SSRS Explorer

image

image

 image

image

image

To Start SSRS Explorer go to Program Files –> SSRS Manager

image

In order to connect to any existing SSRS server we need to first configure the server settings

Click Application–> Servers

image

I generally remove all the default servers that show up and click add

image

Enter the server URL. For SSRS 2005 the url will be http://<<servername>>/reportServer/ReportService2005.asmx

If you’re current windows login id has access to SSRS server then check the windows authentication check box, else enters the credentials for SSRS

image

Click Save –> Close

To Connect to Devl SSRS server, click connect –> devl.

image

At this point the explorer queries the SSRS web service and constructs the tree view structure

image

How to move report from one folder to another on the same server

Right click on the report and select move

image

Select the destination folder

image 

Click Ok

image

To move multiple files select all of them and click move

image

Moving Reports or objects from one server to another (Typically moving from devl to test or Prod)

Here I am moving the reports from my localhost to the development server. I want to move the all the files in My Reports folder to devl server

Step 1: Download the files you want to deploy to devl server from localhost, to your local drive.

Step 2: Connect to the destination server which is devl here

Step 3: Upload them

Downloading files

image

image

You may want to preserve folder structure if you are downloading folder with subfolders

To upload the files to the development server connect to the Devl server as we did earlier, then select the destination folder and upload all the files or the entire folder

image

image

If you do not want to overwrite existing files on the destination server choose no, most of the times you want to overwrite the old versions with the new on.

image

 

image

Associate Data Source for the Report

image

 

Select a single report or multiple reports right click and select set data source

image

From the list of available data source select the one

You can do almost all the admin activities using the ssrs explorer. Like adding a data source, modifying a data source. You would even administer security from the explorer. But I prefer to do security related stuff from report manager website

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s