Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / database / SQL-Server / SQL-Server-2014

Create SSRS Report in SQL Server

4.56/5 (7 votes)
12 Dec 2014CPOL3 min read 35.8K  
In this article, we will learn how to create a SSRS report, how to configure the reporting server and how to deploy the report.

Introduction

We will learn how to do the following in this article:

  • Create a SQL Server Reporting Services (SSRS) report
  • Configure the reporting server
  • Deploy the report

Background

SSRS is a tool for building a report and publishing it. If we need to build a report using the SSRS tool, then we need to install Business Intelligence Development Studio (BIDS). Then, we are able to make the report.

Create SSRS Report->

Start VS 2012, then go to "File" -> "New" -> "Project...".Image 1

Go to the Business intelligence Tab, then select Project server project Template, then change the name of the project, then click OK.Image 2

Then, right-click on the Report folder that is in Solution Explorer, then click on the Add New Report command as shown.

Image 3

Then, in this Report wizard, click on the next button.

Image 4

Then, select the data source in which we need to rename the name of data source and select the type of data source and then click on edit button for connection string.

Image 5

Here, we need to configure data source connection string. For that, we need to provide server name and enter server authentication and select your database, then click ok.

Image 6

After configuration, we can see connection string in this box. Then, click Next button.

Image 7

When we click on next window, this window appears. This window appears because we have selected SQL server authentication in the previous window. Here, we need to put user name and password of server which we have entered in the previous window.

Image 8

Then, this window appears. In this window, we need to write T-SQL statement according to our requirement and then click on Next button. Here, I want to show all the data of employee in report.

Image 9

Then this window appears. In this window, we need to select report type. Here, two options are available, one Tabular and the second one is Matrix. You can choose type according to your own requirement and then click on Next button. Here, I select tabular format for the report.

Image 10

Then, this window appears. In this window, we can configure data display. Then, click next button.

Image 11

Using this window, we can select table style and then click Next button.

Image 12

Then, this window appears. This is the last step of report configuration with data source. Then, Click on finish button.

Image 13

After click on finish button, we can see this window. Here, we can see two tabs, one is Design and another one is Preview. When we click on preview tab, then we can see preview of data.

Image 14

When we click on preview tab, then we need to put authentication detail, then click on View Report button.

Image 15

Here, we can see the preview of data.

Image 16

Configure Reporting server

After creating report, we need to deploy the report to the report server.

But before deployment of report, we need to configure report server.

For configuration of reporting services, we need to open SQL server Reporting services Configuration manager.

Image 17

Here, we need to configure server. For this, put server name and instance name from dropdown list. Then, click on Connect button.

Image 18

From this window, we get report server URL. Click on this URL.

Image 19

After clicking on URL, you might get this error.

Image 20

If you get this error, then fix this error. Run your Internet Explorer as administrator and copy URL from error page and paste in the other window of Internet Explorer. After that, we are able to see this window.

Image 21

Deploy Report

After configuration of report server, we need to set the properties of project.

For that, right click on project, then select properties option.

Image 22

Provide this http://yourcomputername/ReportServer_MSSQL URL in TargetServerURL property, then click on Apply button and then OK.

Image 23

Then, we can deploy own project.

Before deployment of project, we need to run VS2012 as administrator.

Image 24

After successful deployment, we see success message in output window.

Image 25

Then we see the deployed report here.

Image 26

Clicking on this report, put authentication detail, then click on view report window. Then, we are able to see the deployed report.

Image 27

Thanks for reading my article.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)