Getting Started With SSRS 2016 - Part Two

In this article, we will discuss how we can create an SSRS Report using Report Wizard in SQL Server Reporting Services 2016. We have already discussed how to create an SSRS Report without using Report wizard, how to deploy the SSRS Report into Reporting Server, and how to run the Report Application in my previous articles. If you want to learn SSRS Series, you can read the below link:

In this article, we will see the following.

  • How to setup SSRS Environment
  • How to create a Table in database
  • How to create an SSRS Project
  • How to deploy the Report
  • How to run the Report

Prerequisites

We should have some basic knowledge of SQL Server Query and Visual Studio Tool for creating an SSRS Reports using Visual Studio 2015.

  • SQL Server Basic Query
  • Visual Studio 2015

How to setup the SSRS Environment

If you want to know how to setup the SSRS Environment procedure and SSDT, you can read my previous article Getting Started with SSDT 2016 using Visual Studio 2015.

How to create a Table in database

Firstly, create a Student table using SQL Server Management Studio in SQL Server database.Then, you can add student record in the Student table.

  1. create table Student  
  2. (  
  3.    StudentId int primary key,  
  4.    StudentName varchar(20),  
  5.    StudentCourse varchar(20),  
  6.    StudentFees money,  
  7.    StudentDOB date,  
  8.    StudentStatus varchar(20)  
  9. )  
  10. select * from Student  
  11. Insert into Student values (1, 'Santhakumar''DotNet', 15000, CONVERT(date,'11/06/1982'), 'Active')  

How to Create an SSRS Project

 

  • Open Visual Studio 2015.
  • Go to File >> New >> New Project.
  • The "New Project" window will open. Select an installed template like “Reporting Services” in Business Intelligence Template, then select the Report Server project, and type Project Name StudentReport.
  • Choose the project location path and click OK button.

 



The "Report Wizard" window will open. Click the "Next" button.



The "Select the Data Source" window will open. Click the "Edit" button.


  • The "Connection Properties" window will open.
  • Type the Server Name, select Authentication, User name, Password, and select or enter a database name.
  • Finally, you can test the database connection.
  • If succeeds, click the OK button.


The "Select the Data Source" window will open. Select new data source, connection string, and click the "Next" button.



The "Data Source Credentials" window will open. Type the User name, Password, and click the OK button.



The "Design Query" window will open. Click the Query Builder.



The "Query Designer" page will open. Type the query for the table that you want to load the report and execute the SQL query, followed by clicking the SQL icon.



The "Query Designer" window will load the SQL statement for the particular table and click the OK button.





The "Report Type" window will open. Select the report as Tabular and click the "Next" button.



The "Design the Table" window will open. Now, add the table columns to display fields, followed by clicking "Details" button. Then, click the "Next" button.



The "Completing Wizard" window will open. Type the Report Name and click the "Finish" button.



After creating SSRS project report, you can see the solution explorer structure, as shown in the following screenshot



Now, you can see the report design view as following.

 

How to deploy the Report

Go to the Solution Explorer, point the StudentReport project, and right click the StudentReport and point to deploying Student Reports, then click the "Deploy" context-menu item.

 

After successfully deploying the report to Report Server, you will see the information from the output window as shown in the screenshot.

 

How to run the Report

You can see in details on how to run the Report using Report Server in the browser. Firstly, you have to copy the default Report Server Url and paste the same Url into your browser for running the report application.

http://localhost/reportserver


Now, you can run the report application, followed by StudentReport project and click the StudentReport.


Note

You can also read this article at my blog here.

Conclusion

I hope you understood how we can create an SSRS Report using Report Wizard in SQL Server Reporting Services 2016 and how to deploy/run the report application in the Report Server. I have covered all the required things. If you find anything that I missed in this article, please let me know. Please share your valuable feedback, comments, and suggestions to improve future articles.