SSRS nested grouping

Initial steps from: http://www.ienablemuch.com/2012/11/ssrs-simple-grouping.html

This how-to guide shows how to do nested grouping with SSRS. On next post, we will make it dynamic.

14 steps

1

2

3

4. You'll notice there's a duplicate error. We need to hide that column

5

6. We need to merely hide the column, so we can re-use the same report when grouping on columns dynamically

7

8

9

10

11

12

13

14

Done.

Happy Coding! ツ