matrix report

Hello,

Am having this problem, and i have not been able to solve it as yet.

The requirement is to have a matrix like structure such as:

Column Header

Row Header Value1;
Value2;

I was able to create a matrix report using SQL Reporting services 2000, placed the column as well as Row headers, however, the value can be just an aggregate expression, which means I can have only one value as the data. But the requirements is to have multiple values in the data placeholder.

Does anyone have experienced the same problem as me? Any help will be highly appreciated.

Regards

Santosh

You can make like a tree in a Table control. You can add the main value in Header and when u click on it, it can display multiple values in detail row.