Requirements

  • SQL Server 2016 (Microsoft SQL Server Enterprise Evaluation (64-bit).
  • Visual Studio : 2015 (Professional Edition).
  • Microsoft Report Viewer control : Version 11.0.0.0.

Installation and Configuration

  • We need to install SQL Server 2016. The Reporting Services should also be included.
  • We need to install Visual Studio 2015 Professional Edition with SQL Server Business Intelligence Development Studio.


Need to configure SSRS



After configuring the connection,

  • We need to select Web Service URL and we can enter the Virtual Directory name or leave the default Virtual Directory as ReportServer.
  • Subsequently, URLs display the URL with the entered Virtual Directory name.



  • By selecting Web portal URL, we can upload the report or create the report, using Report Builder, by clicking the URLs. We can enter the Virtual Directory name or leave the default Virtual Directory as ReportServer.



  • Deploy the report, using Visual Studio, which will be shown here.
  • We can manage the folders for the reports here.


The screenshots given below help to describe creating reports on the Server. The Business Intelligence Development Studio is used to create the reports.

Step 1



Step 2



Click next.

Step 3

You see the next screen



Give DataSource name and click edit.

Step 4

Choose SQL Server and database. Give the credential details by clicking Edit button.



Step 5

Click Next.



Step 6

Click query builder.



Step 7

Click the symbol (add table), select and add the tables required and click close.

Select the fields required from the Table, it will form a query. Click OK.



Step 8

Click Next.



Step 9

Select report type, followed by clicking next.



Click Next.

Step 10

Design the table. 



Click Next.

Step 11

Add the report name.



Click Finish.

Step 12



Step 13

Select the Preview Tab, give the DataSource credentials and the report will be previewed.



Step 14

The next two steps are important.

  • Build
  • Deploy

Build the report.



Deploy the Report

Right click on project --> Properties-->Change the TagerServerURL to the WebService URL.



Click OK.



After deploying the report, you can see the output.



These two things will be used in the Web Application for rendering the report.

We can see the DataSource created by the given name dsSample and DataSet created for the corresponding DataSource.



Step 15

Load the ConnectionString from the Applications Web.config file.

Step 1

Create the parameter

Parameter --> Right Click --> Add Parameter --> Add the Name of the parameter



Click OK.

Step 2

We can change the properties of the Datasource by right clicking the DataSource --> Properties. 



Click the Expression button (Image with fx).

Subsequently, add the parameter value as the Connection String.



Click OK.

The connection string will be looked, as shown below.



Click OK.

The value of the parameter will be passed from the Web Application as the report parameter.

------------------------------End--------------------------------------------
Output

Next Recommended Readings