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

From the Dataset window, I drop my column axis field into the Columns drop zone. You can see in
Figure 6-50 that the field reference doesn't use an aggregate function like First() or Sum() . This is
because a group was automatically generated to support this column. You'll see the groups after all of
the fields are placed into cells. Figures 6-50 through 6-54 show each of the fields added to a cell.
Figure 6-50
Now for the first row field: the Country.
Figure 6-51
For each country, a group will display repeated date-related information. I drop the Calendar_Year field
to the right of the Country. Note that a light-colored bar on the right edge of the existing text box indi-
cates that a new group will be added.
Figure 6-52
This pattern is repeated for the remaining fields. The row hierarchy now contains the Country,
Calendar_Year, Calendar_Quarter, and Month fields. The Order_Quantity field is dropped into the
center (or pivot) cell. Note that this field will be aggregated using the Sum() function by default. The
expression can be changed to use any appropriate aggregation (such as Avg() or Count() ),
Figure 6-53