Click here to Skip to main content
13,094,732 members (78,316 online)
Click here to Skip to main content
Add your own
alternative version


15 bookmarked
Posted 12 Dec 2014

Create SSRS Report in SQL Server

, 12 Dec 2014
Rate this:
Please Sign up or sign in to vote.
In this article, we will learn how to create a SSRS report, how to configure the reporting server and how to deploy the report.


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


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

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

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

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

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.

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.

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

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.

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.

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.

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

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

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

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.

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

Here, we can see the preview of data.

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.

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

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

After clicking on URL, you might get this error.

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.

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.

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

Then, we can deploy own project.

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

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

Then we see the deployed report here.

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

Thanks for reading my article.


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


About the Author

Software Developer MNC
India India
This member doesn't quite have enough reputation to be able to display their biography and homepage.
Group type: Collaborative Group (No members)

You may also be interested in...


Comments and Discussions

GeneralThanks for sharing useful article Pin
samuel fernandes21-Sep-16 23:04
membersamuel fernandes21-Sep-16 23:04 
QuestionNew Features Pin
Member 1130322612-Dec-14 19:49
memberMember 1130322612-Dec-14 19:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170813.1 | Last Updated 12 Dec 2014
Article Copyright 2014 by pritik889
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid