Monday, January 07, 2013 1:28 AM
i have persons type as my row groups...persons type a divided into 3..man,women and neutral...when i run the report all 3 a display with their total..
man has different value but women and neutral a the same values...so i dont want my matrix to display as this
man = 23
neutral = 109
how can i combine women and neutral to be only 1 row? as below
man = 23
girl= 109 ---->for both women and neutral
- Edited by uttar007 Monday, January 07, 2013 1:29 AM
Monday, January 07, 2013 3:35 AM
Could you give the query and the table with all field?
Tuesday, January 08, 2013 5:13 AMModerator
In order to meet your requirement, please refer to the following steps to redesign the report:
1. Add the Matrix control into the report design surface.
2. In Row groups pane, add a parent group and specify the group expression as follows:
3.Supposing the row group name is "Person". In the data cell of the Matrix data region, specify the value expression as follows:
For more information about Group Expression,please see:
If I have any misunderstanding, please post the dataset query and report structure with us, it benefits us for further analysis.
TechNet Community Support