The Microsoft SQL Server Reporting Services, shortly called SSRS (or SQL Reporting Services), is a server-based reporting platform that creates an rdl file. SSRS provides various services and tools to design data-driven reports. With SSRS, you can create Charts, Maps, Sparklines, tabular, and Matrix reports from the Relational, XML, Excel, and Multidimensional sources.
To develop SSRS charts, or learn SSRS reporting tutorial, you need Visual Studio, SSRS report Builder or BIDS or Sql Data Tools software. So, to understand this SSRS tutorial, download and install BIDS.
You don’t have to be pro, however, try to Learn some basics on sql server, at least Select Statements. It helps you to understand this ssrs tutorial. Before you start practicing this ssrs tutorial, I suggest you download Adventure Works, and adventure works dw databases. Because these are the two databases that we use in this entire SQL Server Reporting Services or SSRS tutorial.
SSRS Data Sources Tutorial
The first step to designing an SSRS Report is to create a data source, which establishes a connection to the database. The second step is to create a dataset that includes queries to retrieve the data source’s actual data. Next, we have to visualize the data from the SSRS dataset by adding charts to the data region.
Please refer to install adventureworks article to understand the steps involved in downloading and installing the Sql Server databases. And refer to the install sql server data tools article to install the data Tools or business intelligence development studio or bids.
- Learn Reporting Services in 28 Days
- SSRS Query Designer
- Creating New Project
- Create a New Report
- Creating Shared Data Source
- Create Shared Dataset
- Creating Embedded Data Source
- Creating Embedded Dataset
- Combine Two Datasets
SQL Reporting Services Report Items
This section of the SSRS tutorial explains the list of available SQL report items and their usage inside a report.
- List of Report Items
- Create New Table Report
- Create Table using Report Wizard
- Creating a New Matrix
- Create Matrix Report Using Report Wizard
- Display Image in Report
- Add TextBox to Report
- Rectangle in a Report
- Create a List Report
SSRS Tutorial on Basic Reports
It covers the basic reporting using the SQL reporting services or SSRS.
- Add Grouping in Table Report
- Adding Row Groups & Column Groups to Matrix Report
- Create a Report using SQL Views
- Create a Report using SQL Stored Procedure
- Add Totals, and Subtotals to Reports
- Add, Or Remove Headers and Footers on Reports
- Global Variables to Report
- Export Reports to PDF, XML, Excel, Word
SSRS Tutorial on Basic Formatting
This SSRS tutorial section covers the basic formatting options
- Format Table Report
- Changing Font and Background Color of a Text Box
- Format Numbers in a Text Box
- Format Date and Time in a Report
- Repeat Headers on Each Page
- Headers Visible While Scrolling
- Filters at Tablix Level
- Filters at Dataset Level
- Sorting Data at Tablix Level
- Interactive Sorting
- Add Alternative Row Color to Report
- Add Row Numbers to Report
Advanced SSRS Reports Tutorial
This SSRS tutorial section covers the advanced topics.
- Add Custom Code inside a Report
- Calculated Fields
- Document Map
- Drill Down Reports
- Drill Through Action
- Matrix Drill Down
- Go to URL Action
- Page Breaks
SSRS Parameters Tutorial
This section of the SSRS tutorial covers the Parameters and using them as the Report Filters. Report Parameters used to filter the report data as per the user sections or the parameter value.
Here, see how to accept the user inputs as the parameter value, assign default values, and multiple values as a parameter. The most important thing is creating a SSRS parameter whose value depends on another parameter. By following these five articles in this SSRS tutorial, you can understand all the above-said things.
- Report parameters
- Drop down list Parameters
- Multi-Valuee parameters
- Multiple Parameters
- Cascading Parameters
SSRS Charts Tutorial
The following are the list of charts available in SQL Reporting Services or SSRS Reporting services.
- SSRS Charts Introduction
- SSRS Area Chart
- Bubble Chart
- Column Chart
- Formatting Column Chart
- Data Bars
- Creating Data Bars in Matrix Report
- Formatting Data Bars
- Funnel Chart
- Creating Radial Gauges
- Creating Linear Gauges
- Formatting Gauges
- Formatting Indicators
- Line Chart
- Pie Chart
- Formatting Pie Chart
- Pyramid Chart
- Radar Chart
- Range Chart
- Scatter Plot
- Stacked Bar Chart
SSRS Report Manager Tutorial
This SSRS tutorial section covers the SQL Report Manager settings and its functionalities.
- SQL Server Reporting Services Configuration Manager
- Change Report Manager Title
- Deploying Reports using BIDS
- Deploy Reports using Report Manager
- Create Shared Data Source in Report Manager
- Cached Reports
- Linked Reports
- Report Parts
- Report Snapshot
- History Snapshots
- Upload Text, PDF, and Image to Report Manager
SSRS Report Builder Tutorial
This section of SSRS tutorial covers the report creation using report builders.