Hi
Matrix reports, commonly known as Pivot tables or Crosstab
reports, summarizes data in more than one dimension.
In this demo, we will create two matrix reports. The first one provides the details of the products sold for a given month, and the second one provides the products sold by each sales person for the given month. Below is the screenshot of the report.
http://www.codeproject.com/KB/aspnet/MatrixReport/pic7.jpg
refer the link for details
http://www.codeproject.com/KB/aspnet/MatrixReport.aspx