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.

The Reporting Services Configuration Manager window opens up as shown under

Reporting Services Configuration Connection

On Clicking the Connect button following screen will appear

Report Server Status

Let us click on the Report Manager URL tab in order to get the Report Server 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

After giving the correct credential the following screen opens

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

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

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 DeployOutput 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.