SSRS Report With VS 2015

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.