---
title: "Creating SSRS (SQL Server Reporting Service) in MSSQL Server 2014"  
description: "Open Sql server data tools referred in the image below:-  Go to File-New-Project. It will open a new dialog .Select Business Intelligence from insta"  
author: "Sunil Singh"  
published: 2016-04-13  
updated: 2020-03-04  
canonical: https://www.mindstick.com/articles/12008/creating-ssrs-sql-server-reporting-service-in-mssql-server-2014  
category: "reporting"  
tags: ["reporting", "sql server"]  
reading_time: 6 minutes  

---

# Creating SSRS (SQL Server Reporting Service) in MSSQL Server 2014

**Open Sql server [data tools](https://yourviews.mindstick.com/view/83849/top-big-data-tools-for-data-science-and-machine-learning-projects) referred in the image below:-**\

![Creating SSRS (SQL Server Reporting Service) in MSSQL Server 2014](https://www.mindstick.com/mindstickarticle/457f1a11-3e06-4800-9ab8-365d28335960/images/989f8372-fdc6-42cb-b6ba-c9c222c557ca.png)

Go to File->New->Project. It will open a new dialog .Select Business Intelligence from installed templates -> Reporting Services. When you select Reporting Services on right side of there will be two options*- Report Server Project Wizard* and *Report Server Project* .Select desired option .If you want to create report from wizard then choose Report *Server Project Wizard* .it will guide you how to create report .if you choose *Report Server Project* it will create empty report project .Here I will create report through wizard. The following image show the new project dialog-

![Creating SSRS (SQL Server Reporting Service) in MSSQL Server 2014](https://www.mindstick.com/mindstickarticle/457f1a11-3e06-4800-9ab8-365d28335960/images/d7a8c38e-67f9-40ea-9f12-fa34d36708d6.png)

Now give [your project](https://www.mindstick.com/forum/156583/best-way-to-link-bootstrap-file-in-your-project) name and solution name and select desired location in new project dialog and click ok.it will display a new dialog shown below-

![Creating SSRS (SQL Server Reporting Service) in MSSQL Server 2014](https://www.mindstick.com/mindstickarticle/457f1a11-3e06-4800-9ab8-365d28335960/images/72e99fc0-c21c-4f43-aa1b-12c7d965531a.png)

Click on *Next button it will open new dialog called as select data source dialog show below-*

![Creating SSRS (SQL Server Reporting Service) in MSSQL Server 2014](https://www.mindstick.com/mindstickarticle/457f1a11-3e06-4800-9ab8-365d28335960/images/236c868a-4d35-4bd5-b20e-3dcc684e6a0a.png)

Give [data source](https://www.mindstick.com/forum/160659/how-do-you-create-a-custom-filter-to-filter-any-text-in-the-data-source-in-angularjs) desired name and select type [Microsoft SQL](https://www.mindstick.com/forum/159597/my-sql-server-vs-microsoft-sql-server-which-one-better) Server and enter [connection string](https://www.mindstick.com/articles/17/connection-string) in text box or *click on Edit button.* Edit [button click](https://www.mindstick.com/forum/568/check-condion-before-post-page-on-button-click-in-jquery-or-javascript) open a new connection properties dialog. Enter [server name](https://answers.mindstick.com/qa/110129/how-to-change-discord-server-name), login server details and enter or select desired database *.Click ok.* If want to test connection click on *Test Connection* button *if connection succeeded it will display success message box.*

![Creating SSRS (SQL Server Reporting Service) in MSSQL Server 2014](https://www.mindstick.com/mindstickarticle/457f1a11-3e06-4800-9ab8-365d28335960/images/6bcfa365-3c09-4899-a280-f47a6880cc3e.png)

If click on ok button in connection properties dialog it return back to data source dialog click on *Credentials* button it will display the following dialog-

![Creating SSRS (SQL Server Reporting Service) in MSSQL Server 2014](https://www.mindstick.com/mindstickarticle/457f1a11-3e06-4800-9ab8-365d28335960/images/c97154ee-d6ef-4e46-a60d-a3c6b9fd4767.png)

Enter the [user name](https://answers.mindstick.com/qa/30717/how-to-retrieve-user-name-in-case-of-window-authentication) and password for data source or select *use windows authentication* whatever applicable for your setting and click ok button in data source dialog click on next button it will open the following design query dialog-

![Creating SSRS (SQL Server Reporting Service) in MSSQL Server 2014](https://www.mindstick.com/mindstickarticle/457f1a11-3e06-4800-9ab8-365d28335960/images/0fc647a0-2142-46dc-82c3-539b0b0a9e83.png)\
\
My query is-\

```
SELECT        emp.emp_id, emp.emp_name, emp.emp_address, emp.emp_contact_no, emp.emp_zipcode, st.state_name, cty.city_name, c.country_nameFROM            employee AS emp INNER JOIN                         country AS c ON emp.emp_country_id = c.country_id INNER JOIN                         state AS st ON st.state_id = emp.emp_state_id INNER JOIN                         city AS cty ON cty.city_id = emp.emp_city_id
```

You can user query builder or write your own query and click on *Next button* display the following dialog-

![Creating SSRS (SQL Server Reporting Service) in MSSQL Server 2014](https://www.mindstick.com/mindstickarticle/457f1a11-3e06-4800-9ab8-365d28335960/images/9428dc15-0859-49f6-9119-56082b72fcda.png)

Select Tabular option and click next it will display the following table design dialog-

![Creating SSRS (SQL Server Reporting Service) in MSSQL Server 2014](https://www.mindstick.com/mindstickarticle/457f1a11-3e06-4800-9ab8-365d28335960/images/90bcce58-50ae-4d73-ae81-12d5058ba82c.png)\

Select desired field for page, group and details .in my case I choose *state_name* as group and click on next button it will display the following table layout dialog –

![Creating SSRS (SQL Server Reporting Service) in MSSQL Server 2014](https://www.mindstick.com/mindstickarticle/457f1a11-3e06-4800-9ab8-365d28335960/images/03a459bb-3b9b-49b6-8c41-7fdc76533a9a.png)

Select desired option and click on next button it will display the following table style dialog-

![Creating SSRS (SQL Server Reporting Service) in MSSQL Server 2014](https://www.mindstick.com/mindstickarticle/457f1a11-3e06-4800-9ab8-365d28335960/images/538225a9-0290-4227-8110-85470597209a.png)

Select table style according to requirement or continue with the default style and click on *next button-* it will display the followingdeployment location dialog-

![Creating SSRS (SQL Server Reporting Service) in MSSQL Server 2014](https://www.mindstick.com/mindstickarticle/457f1a11-3e06-4800-9ab8-365d28335960/images/6792d9f0-7ce5-435d-9238-2df83d0989fd.png)

Enter deployment folder name and report server url as requirement or continue with [default settings](https://answers.mindstick.com/qa/95596/how-do-i-reset-firefox-to-default-settings) and click on next button it will display the following dialog-

![Creating SSRS (SQL Server Reporting Service) in MSSQL Server 2014](https://www.mindstick.com/mindstickarticle/457f1a11-3e06-4800-9ab8-365d28335960/images/430e58d3-eb03-406b-858d-36e78a1bd917.png)

Enter report name and click on finish button. Design view of report dialog-

![Creating SSRS (SQL Server Reporting Service) in MSSQL Server 2014](https://www.mindstick.com/mindstickarticle/457f1a11-3e06-4800-9ab8-365d28335960/images/05e934fc-06fc-440a-b1cb-fa6579734817.png)

Report preview dialog-

![Creating SSRS (SQL Server Reporting Service) in MSSQL Server 2014](https://www.mindstick.com/mindstickarticle/457f1a11-3e06-4800-9ab8-365d28335960/images/bd52ced5-7562-41af-8828-70eb22142cdb.png)

\

My table structure -

```

```

```
USE [EmployeeDb]GO/****** Object:  Table [dbo].[city]    Script Date: 4/13/2016 7:10:31 PM ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[city](    [city_id] [bigint] IDENTITY(1,1) NOT NULL,    [state_id] [bigint] NULL,    [city_name] [nvarchar](max) NULL, CONSTRAINT [PK_city] PRIMARY KEY CLUSTERED (    [city_id] ASC)WITH
 (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GO/****** Object:  Table [dbo].[country]    Script Date: 4/13/2016 7:10:31 PM ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[country](    [country_id] [bigint] IDENTITY(1,1) NOT NULL,    [country_name] [nvarchar](max) NULL, CONSTRAINT [PK_country] PRIMARY KEY CLUSTERED (    [country_id] ASC)WITH
 (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GO/****** Object:  Table [dbo].[employee]    Script Date: 4/13/2016 7:10:31 PM ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[employee](    [emp_id] [bigint] IDENTITY(1,1) NOT NULL,    [emp_name] [nvarchar](max) NULL,    [emp_city_id] [bigint] NULL,    [emp_country_id] [bigint] NULL,    [emp_state_id] [bigint] NULL,    [emp_address] [nvarchar](max) NULL,    [emp_contact_no] [nchar](15) NULL,    [emp_zipcode] [numeric](6, 0) NULL, CONSTRAINT [PK_employee] PRIMARY KEY CLUSTERED (    [emp_id] ASC)WITH
 (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GO/****** Object:  Table [dbo].[state]    Script Date: 4/13/2016 7:10:31 PM ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[state](    [state_id] [bigint] IDENTITY(1,1) NOT NULL,    [country_id] [bigint] NULL,    [state_name] [nvarchar](max) NULL, CONSTRAINT [PK_state] PRIMARY KEY CLUSTERED (    [state_id] ASC)WITH
 (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOSET IDENTITY_INSERT [dbo].[city] ON INSERT [dbo].[city] ([city_id], [state_id], [city_name]) VALUES (1, 1, N'allahabad')INSERT [dbo].[city] ([city_id], [state_id], [city_name]) VALUES (2, 1, N'kanpur')INSERT [dbo].[city] ([city_id], [state_id], [city_name]) VALUES (3, 1, N'lucknow')INSERT [dbo].[city] ([city_id], [state_id], [city_name]) VALUES (4, 1, N'banaras')INSERT [dbo].[city] ([city_id], [state_id], [city_name]) VALUES (5, 3, N'Mumbai')SET IDENTITY_INSERT [dbo].[city] OFFSET IDENTITY_INSERT [dbo].[country] ON INSERT [dbo].[country] ([country_id], [country_name]) VALUES (1, N'india')SET IDENTITY_INSERT [dbo].[country] OFFSET IDENTITY_INSERT [dbo].[employee] ON INSERT
 [dbo].[employee] ([emp_id], [emp_name], [emp_city_id],
[emp_country_id], [emp_state_id], [emp_address], [emp_contact_no],
[emp_zipcode]) VALUES (1, N'Sunil', 1, 1, 1, N'Teliarganj allabad',
N'9090909090     ', CAST(211003 AS Numeric(6, 0)))INSERT
[dbo].[employee] ([emp_id], [emp_name], [emp_city_id], [emp_country_id],
 [emp_state_id], [emp_address], [emp_contact_no], [emp_zipcode]) VALUES
(2, N'Manoj Kumar', 2, 1, 1, N'Civil Lines ', N'7887878778     ',
CAST(324434 AS Numeric(6, 0)))INSERT [dbo].[employee] ([emp_id],
[emp_name], [emp_city_id], [emp_country_id], [emp_state_id],
[emp_address], [emp_contact_no], [emp_zipcode]) VALUES (3, N'Tarun
Kumar', 1, 1, 1, N'beli allahabad', N'3243545667     ', CAST(211002 AS
Numeric(6, 0)))INSERT [dbo].[employee] ([emp_id], [emp_name],
[emp_city_id], [emp_country_id], [emp_state_id], [emp_address],
[emp_contact_no], [emp_zipcode]) VALUES (4, N'Aditya Kumar Patel', 5, 1,
 3, N'East Andheri   Mumbai', N'3445656778     ', CAST(422002 AS
Numeric(6, 0)))SET IDENTITY_INSERT [dbo].[employee] OFFSET IDENTITY_INSERT [dbo].[state] ON INSERT [dbo].[state] ([state_id], [country_id], [state_name]) VALUES (1, 1, N'uttar pradesh')INSERT [dbo].[state] ([state_id], [country_id], [state_name]) VALUES (2, 1, N'punjab')INSERT [dbo].[state] ([state_id], [country_id], [state_name]) VALUES (3, 1, N'maharashtra')INSERT [dbo].[state] ([state_id], [country_id], [state_name]) VALUES (4, 1, N'madhya pradesh')SET IDENTITY_INSERT [dbo].[state] OFF
```

```

```

```

```

\

---

Original Source: https://www.mindstick.com/articles/12008/creating-ssrs-sql-server-reporting-service-in-mssql-server-2014

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.