Reporting service in MS SQL Server
MS SQL Server has a service for creating very useful reports for businesses.
Purpose of reporting
Reports are often used for 2 purposes - Company Internal Operations and Company External Operations (temporarily translated as internal and external).
Reporting service
This is a service to create report types. Here are 3 requirements needed to create any kind of report.
- Business Process
- Layout
- Query / Procedure / View
BIDS (Business Intelligence Studio until 2008 R2) and SSDT (SQL Server Data Tools since 2012) are the environment to create reports.
Here are the steps to open BIDS / SSDT.
Step 1 - Open the BIDS / SSDT depending on the version of MS SQL Server you use. The screen below will appear. In this example is SSDT.
Reporting service in MS SQL Server Picture 1
Open the SSDT environment in MS SQL Server to create a report
Step 2 - Go to File in the left corner, select New and select Project. The screen below will appear.
Reporting service in MS SQL Server Picture 2
Create a new project
Step 3 - Select the reporting service at the Business Intelligence section in the left corner as shown below.
Reporting service in MS SQL Server Picture 3
List of reporting services
Step 4 - On the screen above, select the Report Server Project Wizard (follow the steps under available WIzard) or Report Server Project (choose customized settings) according to your requirements to create the report.
Readers can learn more about reporting in SQL Server at the article: Introduction to SQL Server Reporting Services and Instructions for creating and editing reports in SQL Server Reporting Services
Previous article: High Availability - Availability of MS SQL Server
Next lesson: Execution Plans - Execution plan in MS SQL Server
You should read it
- Introduction to SQL Server Reporting Services
- Instructions for creating and editing reports in SQL Server Reporting Services
- How to start and stop services in MS SQL Server
- The difference between web server and app server
- How to set up your own Git server on Linux
- Network basics: Part 3 - DNS Server
- What is VPS? VPS used to do? What is VPS different from Server?
- SQL Server 2019 - Microsoft Relational Database Management System
- Analysis services in MS SQL Server
- New points in SQL Server 2017
- Instructions for installing MS SQL Server
- Learn about the architecture of MS SQL Server