how to add 2 rows in matrix in ssrs reports.

i have name,type,count these 3 are columns

but i need name and type are 2 rows and count are columns in matrix.any one help me how can i do this

you need to add two row groups name followed by type I guess

Can you show the expected report format. That will help us to understand what you're after

this is the format they expected

in this ass --name

f,m -- type

Hi visakh,

Please can you reply me for this report,its urgent

Hi MS SQLSERVER,

Per my understanding that you want to get the data to display as layout of the snapshot you have provided, right?

I have assumed that you have some sample data in the table which have the structure as below:

If so, you can design the report by using the Tablix instead of the Matrix to achieve this. Details information below for your reference:

1. Create an Tablix and drag the Type and Count into the tablix and then right click the "Type" to add an Parent row group based on field "Name"(remember to check the "Add Group header" and "Add group footer")
2. Select the entire parent row group and click "Delete columns" to delete the column1(Name)
3. Add the name field in the row1 (the row at the top of the value field "Type"
   

If you still have any problem, please provide us the sample data of the table.

Any problem, please feel free to ask.

Regards
Vicky Liu