Chapter-2 : Report Deployment on SQL Server 2012 Reporting Server

In the previous chapter the tutorial was about creating Tabular SSRS Report.This SSRS Report need to be deployed on reporting server. To do so we need to know the name of the report server. It can be found out from the Reporting Services Configuration Tools.




Download Full Tutorial for Chapter-2-Report-Deployment-on-SQL-Server-Reporting-Server in PDF Format

Reporting Services Configuration Tools
Reporting Services Configuration Tools

The Reporting Services Configuration Manager window opens up as shown under

Reporting Services Configuration Connection
Reporting Services Configuration Connection

On Clicking the Connect button following screen will appear

Report Server Status
Report Server Status

Let us click on the Report Manager URL tab in order to get the Report Server URL.




Report Manager URL
Report Manager URL

Click on the URL and we will be asked to enter the Windows credentials, provide the administrator credential of your system.

provide the administrator credential of your system
Provide the administrator credential of your system

After giving the correct credential the following screen opens

image012

Report Definition Language File (rdl) gets generated in our earlier demo in Chapter-1. RDL is basically a XML document file that contains all the information about how we design our report. As soon as we deploy the report, the rdl file gets inserted into the Report Server Database. We can query the catalog table to get the information about the same. We will look into that part shortly.

Now let us come back to our SSRS project developed in Chapter-1.  Open the project and right click on the BasicSSRS1 project’s properties menu.

BasicSSRS1 project's properties
BasicSSRS1 project’s properties

The project properties page will open and we have to enter Target Server URL obtained from the Report Manager URL of the Reporting Services Configuration Manager.

Enter Target Server URL obtained from the Report Manager URL
Enter Target Server URL obtained from the Report Manager URL

Type Target URL as “http://akanksha/ReportServer”. After we click on the OK button , choose the project, right click and click on the Deploy from the available context menu.



Click on the Deploy
Click on the Deploy
Output Screen after Deployment
Output Screen after Deployment

We will receive a success message if reporting project will deploy successfully. At this point if we query our Catalog table by using the same query as described above, we will receive the below output. So our report has been inserted into the Report Server Database. We can also figure out that, the rdl content has been inserted into the Content column (whose type is image) of the Catalog table.

Select [Report Name] = Name, [Rdl Data]= CAST(CAST(Content As Varbinary(Max)) As XML) From Catalog Where Type = 2

image022

Click the URL available in the Report Manager URL and we will get the below screen.

image024

Now Click on the BasicSSRS1 and it will show the list of available report as shown below

image026

Click on the ReportSSRS1 , it will ask for parameter “City” and after giving city the procedure will execute as shown below.

Provide the value for parameter “City”
Provide the value for parameter “City”

Previous Related Post:

Chapter-1: Creating a basic Tabular SSRS Report using Report Wizard
Chapter-2 : Report Deployment on SQL Server 2012 Reporting Server
Chapter-3:Opening/Calling the deployed SQL Server Reporting Server report from Asp.net
Chapter-4 Creating SSRS Matrix Report / Cross Tab Report

The process of deploying the .rdl report to SQL Server is Completed here.




One thought on “Chapter-2 : Report Deployment on SQL Server 2012 Reporting Server

  1. Pritha Mitra is a content professional who creates
    on a variety of subjects consisting of charm care and also laser hair
    elimination treatments.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

three × three =