Figure 3. Add Drilldowns.
You can use SQL Server's reporting wizard to create stepped layouts with subtotals, using the same query you'd use for a block layout. Stepped layouts provide a drilldown option using plus and minus signs to reveal/hide detail data.