Basic Report Design - Professional SQL Server 2005 Reporting Services - page 111

Subtotals
Although Reporting Services generically refers to these types of expressions as subtotals, they may be
used to perform any aggregation of grouped data. Subtotals may be added to a table's footer row, to the
list control, or in the detail or grouping cells of a matrix. The following table is a list of aggregate func-
tions supported by Reporting Services.

Average for all values in a range.

Avg

Count of all non-null values in a range.

Count

Count of unique values in a range.

CountDistinct

Count of all rows in a range, regardless of null values or
uniqueness.

CountRows

First value in a range based on current sort order.

First

Last value in a range based on current sort order.

Last

Highest value in a range.

Max

Lowest value in range.

Min

Standard deviation of non-null values.

StDev

Population standard deviation of non-null values.

StDevP

Sum of all values in a range.

Sum

Variation of non-null values.

Var

Population variance of non-null values.

VarP

Using the table item in Figure 4-56, let's take a closer look at the summary rows and their aggregated
values. In this example, a table that has groupings on the Category and SubCategory fields is created.
Note that the grouping numbers in the row markers next to each row indicate the grouping level. The
detail row is selected and sandwiched between grouping levels 1 and 2. In the grouping footers and the
report footer, the aggregate functions Count , Sum , and Avg are used for the Color, StandardCost, and
ListPrice columns. In this report, an additional row is added for each of the grouping footers for the
columns (see Figure 4-56).

Figure 4-56