A SSRS Matrix report is very similar to a Tabular report, but it displays a data grouped by columns and rows, with aggregate data at the intersections. It is similar like a SQL Pivot to transform data from row-level to columnar data .
SQL SERVER REPORTING SERVICES
SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft.
How to Create a New Project in SSRS ?
A shared data source is a set of data source connection properties that can be referenced by multiple reports, models, and data-driven subscriptions that run on a Reporting Services report server .
SSRS Shared Dataset is a dataset which is created by using Shared Data Source and deployed to Report Server. Shared Dataset can be used by multiple reports.
SSRS Detail Report or Tabular Report .
To Creating a SSRS Detail Report , First we have to create new project and create a data source and data set . We can also take an existing project solution .
If you are new to SSRS report then , first read the following posts