I am trying to add two adjacent groups inside another row group in matrix.However, I can't getaggregations to show for both groups. Numbers are shown only for the second group.How to reproduce this:1.Put matrix on report2. Fill rows, columns and data3. click on row group, add parent group 4. click on inside row group, add group adjacent before5. add aggregations for new groupsI 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!

Hi,Check this article http://technet.microsoft.com/en-us/library/ms157334.aspxfor 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

Hm, i don't find anything useful in the above article.Here are some screenshots:http://www.belisa.si/misc/matrixproblem1.jpghttp://www.belisa.si/misc/matrixproblem2.jpgThe 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

I'm having a similar problem.1) Put a table on a report.2) Add a row group.3) Add a column group3) 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.

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.

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=519660Thanx!

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

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 youLuis Simes

Jerry, thanks, this workaround works! :)

same issue here has this been solved in a SP or CU yet?- www.pmOne.com -

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 Thanks for your instruction! It's comprehensive, This is what I'm looking for.