Introduction
This article demonstrates how to create an SSRS report. This article begins with an SSRS Introduction, then the use of SSRS, and finally step-by-step creation of a report.
What is SSRS?
SSRS is a server-based reporting platform. It provides tools and services to create, manage and deploy reports.
We can use SSRS for
- Business Reporting
- Ad hoc Reporting
- Embedded Reporting
- Portal Integration
Report Development Process
![Report-Development-Process.jpg]()
Step 1
Start => All Programs => SQL Server 2008 R2 => SQL Server Business Intelligence Development Studio.
</span>
Step 2
File => New => Project
Business Intelligence Project => Report Server Project.
Give Project Name ... Select Location... Click OK
</span>
Step 3
Right-click on Reports and Select Add New Report.
</span>
Step 4
Click on the Next Button.
</span>
Step 5
Give a Data Source name and Click on the Edit Button.
 </span>
Step 6
Select Server Name
Select "Use SQL Server Authentication" Radio Button
Give User name and Password
Select Database Name and Click on the "OK" button.
</span>
Step 7
Press the Next Button
</span>
Step 8
Click on the "Query Builder ..." button, as in:
</span>
Step 9
Right-click and select Add Table
Select Table and Click on the Add button
</span>
Step 10
Select all columns and press the ok button
</span>
Step 11
Click on the Next Button
</span>
Step 12
Select Tabular Option and Click on the Next Button
</span>
Step 13
Select PlayerName for the Group list, and the Rest is for Details
Click on the Next Button
</span>
Step 14
Select the Stepped option and Click on the next button
</span>
Step 15
Select a table style and press the next button
</span>
Step 16
Give the Report Name and Press the Finish Button
</span>
Step 17
PlayerReport.rdl is added in the Reports folder, and you can see the rdl file in design mode.
</span>
Step 18
To see the preview of the report, Click on the preview tab
</span>
Conclusion
This is a fundamental and simple report of SSRS. You can also customize table layout, style, report type, etc. In this report, I have used only a single table. You can also create a report using multiple tables with the help of joins.