Sql Server Reporting Services(SSRS)

SQL Server Reporting Services:-

SQL Server Reporting Services (SSRS) is a server-based report development software.SSRS is a Microsoft SQL reporting, that helps you to create, deploy and manage reports.In this reporting tool, we use Microsoft SQL server, fetch the required data to creating the connection. After creating the connection create graphical design.All these reports can be viewed via a web browsers.

Step 1: Open Sql Server Data Tool.(Click for downloading SSRS Tool)
Step 2: Click On FIle>New>Project>Select Report Server Project.
Sql Server Reporting Services

Sql Server Reporting Services
Step 3: Click on Reports folder and select Add New Report.Report Wizard will be open, Click on Next button.

[AdSense-A]

Sql Server Reporting Services

Sql Server Reporting Services
Step 4: Now create database connection to report.Click on Edit button

Sql Server Reporting Services
Step 5: Define Connection Properties, Select Server Name and Database Name, Test connection and click OK

Sql Server Reporting Services
Step 6: Connection created successfully.Go to query builder wizard to click on Next.

Sql Server Reporting Services
Step 7: Paste Required sql query here check data to click on Query Builder.

Sql Server Reporting Services
Step 8: When you click on next a Report wizard of Select The Report Type will be appear, Select the Report Type you want to Show to user and Click on Next.

[AdSense-A]

Sql Server Reporting Services

Step 9: ==============

Sql Server Reporting Services

 

Step 10: Choose the Table style as u want to show report format color.

Sql Server Reporting Services

 

Step 10: Type Report name in Report Name section.

SSRS_Report_12

 

Step 11: Click to Next button, Your Report is here now you can design according to you.

SSRS_Report_13