IT Developer Zone-Asp.Net,C#,JQuery,SQL,SSIS,SSRS

In this tutorial, we will see when and how to create a simple matrix report in SSRS.
Need of Matrix Report?
Matrix Reports are required where you have to display some aggregated data and at least one of grouping column need to displayed as column in the report. It is something similar to Pivot we use in normal T-SQL where we convert rows to columns using Pivot...

Query Parameters are used to filter the result set return from the database similar to where condition applied in a T-SQL statement. It limits the number of rows return back from the database to the report, thus improving the performance.
Let's create a report to see how Query Parameters work....

In this article, we will create a simple tabular report in SSRS.
Step 1: Create a Shared Data Source
Step 2: Right Click Reports and then Add New Report, Report Wizard will appear to configure the report. Click Next

Data source contain the information necessary to retrieve the data from the relational database to render the reports. If a data source is not shared, it is stored inside a report and can not be used by other reports.
In general, we need to have a data source that can be used in all the reports in the same project. Such data sources are called as shared data source....