Advanced Report Design - Professional SQL Server 2005 Reporting Services - page 227

In the Grouping and Sorting Properties dialog (shown in Figure 6-60), I use the Visibility tab to set the
group's Hidden property and the toggle item for the parent group. In my experience, this drop-down list
may not show all available items as it should, assuming that the groups are set up correctly. Select or
type the name of the preceding group header text box.
Figure 6-60
Figure 6-61 shows the finished matrix report with customer occupations across the top and the country
and time period hierarchy along the left side. The drill-down features enable users to view aggregated
totals for each country and then the year, quarter, and month. Under each occupation, a column displays
the total number of orders and the average amount for all orders.
Figure 6-61