SSRS Matrix - keep First Group expanded by default and others collapsed

• AR-777

  Ten Centuries

  Points: 1288

  More actions

  October 15, 2010 at 2:02 pm

  #239827

  Hello I have a report with a Matrix which has two groups where 'Grp 2' is toggled by 'Grp 1' so initially the matrix looks like this

  Col 1

  + Grp 1_1

  + Grp 1_2

  + Grp 1_3

  I want to keep the first group (Grp 1_1) expanded by default when the report is rendered and keep the other collapsed like this

  Col 1 Col 2

  - Grp 1_1 Grp 2_1

  Grp 2_2

  Grp 2_3

  + Grp 1_2

  + Grp 1_3

  I can do this in the table but cannot do it in Matrix.. please help.

  Thank you