1

I am trying to show a group level data in a single column. Please find details below.

I have data in database in below format:

enter image description here

The above data can be grouped like below:

enter image description here

How can it be done like below in SSRS (grouping in a single column). Please let me know if its not clear.

enter image description here

Thanks

p2k
  • 2,126
  • 4
  • 23
  • 39

1 Answers1

0

When you create the row groups for Master and Senior levels, you can delete the columns created for the groups without deleting the groups.

When you create the grouping, you can select Group Footer, when you do this should create a new row where you can then put the values for the grouping.

JesalynOlson
  • 503
  • 3
  • 9
  • Thanks for the help. I got it by doing groupings in table. Can it be possible by using Matrix. – p2k Jun 13 '14 at 19:27