Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Combine two row groups results

Answered Combine two row groups results

  • Monday, January 07, 2013 1:28 AM
     
     
    Sign In to Vote
    0

    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

    persons   Total

    =============

    man =      23

    women=    109

    neutral =    109

    how can i combine women and neutral to be only 1 row? as below

    persons   Total

    ===============

    man =      23

     girl=       109 ---->for both women and neutral

    thanks


    • Edited by uttar007 Monday, January 07, 2013 1:29 AM
    •  
     

All Replies

  • Monday, January 07, 2013 3:35 AM
     
     
    Sign In to Vote
    0

    Could you give the query and the table with all field?

     
  • Tuesday, January 08, 2013 5:13 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hello,

    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:
    =IIF(Fields!Persons.Value="man","man","girl")
    3.Supposing the row group name is "Person". In the data cell of the Matrix data region, specify the value expression as follows:
    =IIF(ReportItems!Person.Value="man",SUM(Fields!Total.value),SUM(Fields!Total.Value)/2).

    For more information about Group Expression,please see:
    http://msdn.microsoft.com/en-us/library/bb630426.aspx

    If I have any misunderstanding, please post the dataset query and report structure with us, it benefits us for further analysis.

    Regards,

    Fanny Liu

    Fanny Liu
    TechNet Community Support