SQL Server Reporting Services Introduction
Microsoft SQL Server Reporting Services also called as either SSRS or SQL Reporting Services. SSRS is a business intelligence tool or reporting tool that allows you to create reports.
SQL Server Reporting Services is a Reporting tool that allows you to create reports from a wide variety of sources. SQL Reporting Services Toolbox provides a complete set of tools to create a report ranging from basic reports to most complex reports.
With SQL Reporting Services, you can create Tabular reports (Table, Matrix), Charts, Maps, indicators, Sparkline’s etc. from Relational databases, Multidimensional Databases, and XML files.
SQL Server Reporting Services Work Environment
Below screenshot will show you the SSIS work environment that is used to create SQL Integration Services projects.
As you can see from the above screenshot, we divided the window into different parts
- Solution Explorer: This is a combination of Shared Data Sources, Shared datasets, and Reports. In Create a New Project article, we explained each section in detail.
- Properties: This window is useful to change the property of each item present in a report (including report itself).
- Report Data: Here, you can create Parameters, Data Sources, and Datasets required for this particular report. If you are using Shared data Source then you have to create a local instance of that.
- Design: This is the place where we design our reports
- Row Groups: To add a new group, or to Delete an existing group. You can also use this window to change the properties of a row group. I suggest you refer Grouping in Table Report to understand these Row group settings.
- Column Groups: To add a new column group, or to Delete existing column group item. You can also use this window to change the column group properties. I suggest you refer Grouping in Matrix Report to understand these Column group settings.
SSRS Toolbox provides all the complete set of tools to design the report as per your business reports. You can use these graphs by dragging and dropping them to the work environment.
SQL Server Reporting Services Development
Every SQL Server Reporting Services project is a combination of Data Sources, Data Sets, and Reports.
SSRS data Source is helpful to establish a connection between the Source (from where the source data is) where our data reside and the Report. I suggest you refer to Shared Data Source, and Embedded data Source article to understand the configuration settings.
In SQL Server Reporting Services, Connection Managers helps you to establish the connection between Report and the Data Source.
This is where we create a different kind of reports. For this, we use the Data Sources and datasets that we created earlier. I suggest you to refer Create a New Report article to understand the report creation.
Once you completed the Report Design, you can deploy the Reports into the SQL Server Reporting Manager. I suggest you refer Deploy Reports using BIDS, and Deploy Reports using Report Manager Articles to understand the deployment process.