SSRS: creating a LIKe report pivot table in ssrs 2008 r2

Question

I need to create reoprt in ssrs as a pivot table in MS Excel.

Above the screenshot of my requirement, I got very confused this time. Please provide some recommendations, resources, and links where I find the help I need.

Answer 1

The equivalent of the SSRS table of an Excel pivot table is called a matrix — in SSRS 2008, both regular table reports and matrices are essentially the same thing (as described in the answers to this question ).

You can learn more about using matrices in reports on Microsoft's site, such as in this article describing Table, Matrix, and List objects , or this article describes how to add a matrix to a report .

Alternatively, there are many other resources on the Internet - here are from the links returned by googling "matrix ssrs".