Introduction
In this article, we will see what SQL Server Reporting Services (SSRS) is and understand its client and server components.
Contents
- Hour 1: What is SSRS and determine whether it is installed
- Hour 2: Report using wizard
- Hour 3: First SSRS report
- Hour 4: Report with parameter
- Hour 5: Custom template
- Hour 6: Drill down report
- Hour 7: Sub report
- Hour 8: Report with style
- Hour 9: Report with chart
- Hour 10: Report deployment
- Hour 11: RDL file to ASP.Net
SSRS
SQL Server Reporting Services (SSRS) is a server-based reporting platform. It provides tools and services to create, manage and deploy reports.
To use reporting services you first need to use Visual Studio to design reports. In the report designer, you specify the information you want to retrieve from the data source. Commonly a data source is a relational database like Microsoft SQL Server. Once you identify the information you want to retrieve you can use the report designer to display how you want to present that information. There is a variety of presentation styles available. For example, you can take data and display it in a table in a tabular style. You can also have a chart to display information graphically.
When you are happy with the report and it looks good and it functions correctly then you can take that report and deploy it to a server. And the report server is available to all of your customers or users inside of the company. Reporting services has security features like authenticating users and then authorizing them and making sure they are allowed to view the reports.
We can use SSRS for:
- Business Reporting
- Embedded Reporting
In Business Reporting you want to take information from your data sources and provide it to the users in a format that they can understand. For example, you may have a sales department that wants to see the monthly sales totals for all of the sales people in your organization. It is very easy once you build a report for them to launch the web browser and view the information any time.
It is also possible to take these reports and embed them inside the application. You can embed reports inside a web application or desktop application. There is a web service API exposed by the report server that allows programmatically interacting with the reporting services features.
- Client Components
- Server Components
Client Components
Visual Studio Reporting Projects
- Design Reports
- Deploy Reports
SQL Server Management Studio
- Test Queries
- Performance Analysis
Server Components
- Report Manager
- Manage permissions
- Manage data sources
- Authorization settings
Report Server
- Report Processor
- Scheduling and Delivery
- URL access reports
- Web Service API
SSRS Database
- Metadata
- Report catalog and settings
Determine whether SSRS is installed
To determine whether SSRS is installed or not, you need to check two tools:
- SQL Server Data Tools
- SQL Server Reporting Services
The following procedure can be used to determine whether SQL Server Data Tools installed.
Step 1
- Click on the "Start" button
- Go to "All Programs"
- Expand "Microsoft SQL Server 2012"
- Look for "SQL Server Data Tools"
Now let's check whether SQL Server Reporting Services is installed.
Step 2
- Click on the "Start" button.
- Go to "All Programs".
- Expand "Microsoft SQL Server 2012".
- Expand "Configuration Tools".
- Click on "SQL Server Configuration Manager".
- Click for "SQL Server Services" in the left panel.
- Look for "SQL Server Reporting Services (SQL 2012)" in the right panel.
- Be sure the state of "SQL Server Reporting Services (SQL 2012)" is running.
If you find both of the tools installed in your working environment, then there is no need to install it again.
Next >> Step By Step SSRS in 11 Hours: Hour 2