none
Groups inside groups in matrix

    Question

  • I am trying to add two adjacent groups inside another row group in matrix.

    However, I can't get aggregations to show for both groups. Numbers are shown only for the second group.

    How to reproduce this:
    1. Put matrix on report
    2. Fill rows, columns and data
    3. click on row group, add parent group
    4. click on inside row group, add group adjacent before
    5. add aggregations for new groups

    I am using SSRS 2008.

    Could anyone explain this? Is this bug or feature? I can get this to work if there is no parent group.

    Thanx!
    Thursday, December 10, 2009 2:21 PM

Answers

  • Hi Ivan,

    I am sorry i misunderstand the issue you encouter. I have reproduced it in my test environment, and agree with that you submitted this feedback at Microsoft connect website, and hope it being resolved in the next release of service pack or production. Meanwhile, i share a workaround with you and other community users encountering it. Based on your second post, there are 3 row groups, they are CompanyGroup wich is parent group, No_Name_Desc and IncomeOrCost which are child group and adjacent groups, follow these steps to work around:

    1. Delete the CompanyGroup row group on the matrix.
    2. Drag a List object from the toolbox and set its group on expression just like the matrix's original CompanyGroup's.
    3. Drag the matrix into this newly created List, and add a textbox into this List as the matrix report title and type the expression: =Fields!CompanyGroup.value.
    4.Hide the second or later matrix title (first row) in this list. Right click each Textbox of the matrix's first row and point to Text Box Properties, and type this expression: =IIF(RunningValue(Fields!CompanyGroup.Value,countdistinct,nothing)>1,true,false) to the box of "Show or Hide based on an expression" in the Visibility page.
    5. Manage to adjust these items' layout to make it what you want.

    Please let me know if you have more questions.

    thanks,
    Jerry
    • Marked as answer by Ivan.Z. _ Tuesday, February 16, 2010 2:32 PM
    Thursday, January 07, 2010 6:29 AM

All replies

  • Hi,

    Check this article http://technet.microsoft.com/en-us/library/ms157334.aspx for how to use Adjacent group in matrix. Actually, i didn't understand your issue completely. If the above article doesn't help, you should make your post so clear that we can repro it in our environment.

    Hope this helpful,

    thanks,
    Jerry
    • Marked as answer by Jerry NeeModerator Friday, December 18, 2009 7:15 AM
    • Unmarked as answer by Ivan.Z. _ Friday, December 18, 2009 4:23 PM
    Monday, December 14, 2009 3:22 AM
  • Hm, i don't find anything useful in the above article.

    Here are some screenshots:

    http://www.belisa.si/misc/matrixproblem1.jpg
    http://www.belisa.si/misc/matrixproblem2.jpg

    The problem is that the data is not shown for the first inside row group, only for the second. If there are more row groups inside parent row group, data is shown only for the last row group.

    I hope this is clear enough, if you use the steps in the first post you should reproduce it.

    Thanks so far.

    Ivan
    Friday, December 18, 2009 4:29 PM
  • I'm having a similar problem.

    1) Put a table on a report.
    2) Add a row group.
    3) Add a column group
    3) Add two adjacent row groups which are the children of the first group.
    4) Put an aggregate function inside the intersection of the column group with the row groups.

    The first of the two adjacent row groups is getting no data.  I'm only getting an aggregation in the second row group.
    Thursday, December 31, 2009 7:50 PM
  • I've been over my report and even went through the XML.  As best as I can tell this is a bug in SSRS 2008.   It works fine if you don't have a column grouping on the tablix, but if you do have a column grouping then only the last adjacent row group recieves the data.  The other adjacent row groups render, but contain no detail rows.

    In the mean time I've been forced to hack around the issue by having several parallel tables.
    Tuesday, January 05, 2010 10:05 PM
  • Hi Matt!

    Could you post the workaround you implemented, i might use one too.

    I posted the bug with Microsoft connect, but no response from MS so far. It would be helpful if you could indicate that you reproduced the bug.

    Here's the link to bug report i posted:
    https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=519660

    Thanx!
    Tuesday, January 05, 2010 10:19 PM
  • Hi Ivan,

    I am sorry i misunderstand the issue you encouter. I have reproduced it in my test environment, and agree with that you submitted this feedback at Microsoft connect website, and hope it being resolved in the next release of service pack or production. Meanwhile, i share a workaround with you and other community users encountering it. Based on your second post, there are 3 row groups, they are CompanyGroup wich is parent group, No_Name_Desc and IncomeOrCost which are child group and adjacent groups, follow these steps to work around:

    1. Delete the CompanyGroup row group on the matrix.
    2. Drag a List object from the toolbox and set its group on expression just like the matrix's original CompanyGroup's.
    3. Drag the matrix into this newly created List, and add a textbox into this List as the matrix report title and type the expression: =Fields!CompanyGroup.value.
    4.Hide the second or later matrix title (first row) in this list. Right click each Textbox of the matrix's first row and point to Text Box Properties, and type this expression: =IIF(RunningValue(Fields!CompanyGroup.Value,countdistinct,nothing)>1,true,false) to the box of "Show or Hide based on an expression" in the Visibility page.
    5. Manage to adjust these items' layout to make it what you want.

    Please let me know if you have more questions.

    thanks,
    Jerry
    • Marked as answer by Ivan.Z. _ Tuesday, February 16, 2010 2:32 PM
    Thursday, January 07, 2010 6:29 AM
  • Hello,

    Any development on this bug? I am having the same problem... this is a very annoying bug from Microsoft!

    Please go to the connect issue and vote for resolution!

    Thank you
    Luis Simões
    Sunday, January 31, 2010 9:29 PM
  • Jerry, thanks, this workaround works! :)
    Tuesday, February 16, 2010 2:33 PM
  • same issue here

    has this been solved in a SP or CU yet?


    - www.pmOne.com -
    Friday, July 23, 2010 1:50 PM