ssrs 2008 - How to preserve header rows using a Matrix -

ssrs 2008 - How to preserve header rows using a Matrix -

how preserve header rows using matrix , don't mean preserve them @ page level.

what happens. when click plus/minus on row row info replaced next groups data.

so .. myrow-45-60-04

after click on row .. myrow-secondrow-15-30-100

as can see upon opening main row info replaced "secondrow" on same line.

i need drop downwards , show both rows plus kid row. needs work rows beneath parent row.

myrow-45-60-04 secondrow-15-30-100 thidrow-85-74-5 fourthrow-64-39-9

i worked out solution based on microsoft ssrs page.

right click on grouping cell of row , create row above, within group. should move cell , contents 1 row. each row grouping clicking in box of row name. should see row/column step each row group.

firstgroup sec grouping thirdgroup

as can see separate on screen stepped. grab look secondgroup , move 1 cell backward. align under firstgroup. same thirdgroup.

you should have this

firstgroup secondgroup thirdgroup

looks on top of each other. adjust padding each group. looks pretty tens. default 2 add together 1 first 1 making 12. increment rest see fit.

the next issue column total still stuck on bottom row due fact created rows above it. prepare copying look cells above it. not remove lower expression. need 1 each row.

last step delete empty columns right of moved cells. create sure not delete cells expressions in them. in illustration deleting 2 empty columns

your table should this.

firstgroup | <exp> | <totals> secondgroup | <exp> | <totals> thirdgroup | <exp> | <totals>

this illustration solves 2 issues @ once. keeps grouping level info in tact when expanded , give matrix clean look.

matrix ssrs-2008