Manually Deploy SSRS RDL reports to Report Server using SSRS Report Manager Site URL

Recently I had to deploy some of my SSRS reports in a remote VM, where no Visual studio was present, so I followed the manual process

steps followed are as below

Step 1 : find the report manager URL by opening the Reporting Services Configuration Manager tool and navigating to Report Manager URL shown as below.

1

 

Step 2: Open the URL in Internet Explorer Administrative mode.

2

you will observer my home site has two folders

1- Data Sources     – This is the folder I will create my data sources, which will be referred by my report

2- TestReports  – This is the folder I will upload my reports (.rdl) files.

 

Step 3: Open the Data Sources Folder by double clicking it and then add a new Data source. Make sure you set the data source as active and test the connection string, before clicking the apply button.

3

 

Step 4: Click on the Data Sources link available in the site map to come back to the Data sources folder and see that your created Data source is available

4

Step 5: Go back to the Home by clicking the Home link in the top left corner of the page and then open the TestReports to upload your rdl report into it

5

Step 6:  Click on the Upload File link and then click the Browse button to select your rdl file. and finally click Ok

6

Step 6: Open the Manage command on the report you have just uploaded as shown in the below picture to assign the data source to the report

7

 

Step 7: Select the Data source  link in the manage window and assign the appropriate data source as shown in the below pictures.

8

9

Step 8: Apply the changes and navigate back to the TestReports folder.

 

10

 

Step 9: Run the report by double clicking on it

11

 

Hope this post has helped you…

 

 

 

 

Advertisements
This entry was posted in SQL 2008, SQL Express, SQL Reporting, SQL Server, SSRS, Windows Server 2012 and tagged , . Bookmark the permalink.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s